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 YIn above example, I just need to bring ACCT2, ACCT3, AND ACCT6.
Any expert opinion highly appreciated.
Muhammad