Track skipped records in FDM load

SR Apr 30, 2014 6:54 PM

I am trying to skip some records from FDM load using maps. I provided #script in Target Account column and "Skip" in script column, which is working fine. I can able to skip the records successfully.

Now, I want to see the records which are skipped during the load process. How can I achieve that?

1. Re: Track skipped records in FDM load

Francisco Amores May 2, 2014 7:35 AM (in response to SR)

Are you skipping records in the import format or in the mappings?
Like Show 0 Likes(0)

Actions
2. Re: Track skipped records in FDM load

SR May 2, 2014 7:14 PM (in response to Francisco Amores)

In Mappings.
Like Show 0 Likes(0)

Actions
3. Re: Track skipped records in FDM load

Francisco Amores May 5, 2014 8:25 AM (in response to SR)

If you want to skip records in mappings, you should set target value as "IGNORE". Then these records will not be exported.
You can then filter data in your grid by target value = IGNORE.

Other option would be to create a custom report which shows rows having IGNORE in any target dimension value.

Hope that clarifies
Like Show 0 Likes(0)

Actions
4. Re: Track skipped records in FDM load

SR May 5, 2014 3:13 PM (in response to Francisco Amores)

Thanks Fransisco. I will try these options.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.