Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 10082 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
1. If source is relational then in SQ you can check the
distinct or in mapping we can use distinct in sorter t/r.
2.if flat file then distinct in sorter t/r.
It will not allow nay duplicate data, so target will get
only distinct data.
Let me know if any thing wrong.
Thanks & regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
What are pre and post-session shell commands?
What are the types of caches in lookup?
Explain the code page compatibility?
Tell me about MD5 functions in informatica
What are the issues you have faced in your project? How did you overcome those issues?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is a mapplet/worklet in informatica?
What is workflow? What are the components of the workflow manager?
If informatica has its scheduler why using third party scheduler?
How to call shell scripts from informatica?
What is the meaning of up gradation of repository?
How do you load unique records into one target table and duplicate records into a different target table?
is it possible to index the data in cache of lkp transformation ?
What is a filter transformation and why it is an active one?
