Skip to Content
0
Jul 29, 2016 at 06:45 PM

Transformation File Error

25 Views

Hello Experts,

I have created one transformation file for MD flat file loads.

I need to bring in ID's with the filter of another column FIL_ACCT which has "Y".

Just keep in mind that the column which has "Y" and "N" is not mapped with Dimension properties. I just need to bring ID's from ID column which have value "Y" in column FIL_ACCT.

Following is the scenario:

ID FIL_ACT ACCT1 N ACCT1 N ACCT1 N ACCT1 N ACCT2 Y ACCT3 Y ACCT4 N ACCT4 N ACCT4 N ACCT5 N ACCT5 N ACCT5 N ACCT5 N ACCT6 Y

In above example, I just need to bring ACCT2, ACCT3, AND ACCT6.

Any expert opinion highly appreciated.

Muhammad