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
- 10109 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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the performance considerations when working with aggregator transformation?
Explain the scenario which compels informatica server to reject files?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are junk dimensions?
What are mapplets?
What are the different options available for update strategy?
What are the limitations of joiner transformation?
What is rank transformation in informatica
What is enterprise data warehousing?
Define filter transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Under which circumstances, informatica server creates reject files?
How can one identify whether mapping is correct or not without connecting session?
