Interested to Buy Any Domain ? << Click Here >> for more details...
how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
- 5 Answers
- 11650 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What will be the approach?
what is the -ve test case in your project.
what is size of u r database?
how we can load rejected record's at run time?(not through bad files)
Did u used latest transformations of 8.6.0? for what?
What is the difference between a repository server and a powerhouse?
How identifying bottlenecks in various components of informatica and resolving them?
What all join we can perform in LOOKUP transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to load last n records of file into target table - informatica
Quickly characterize reusable change?
Design a mapping to load a target table with the following values from the above source?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the commit type if you have a transaction control transformation in the mapping?
What is a passive transformation?
