How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 9112 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
Implementation methodology
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Have you worked with/created Parameter file
What are the prerequisite tasks to achieve the session partition?
how to load dimension table and fact table. plz tell me the steps.
What is meant by lookup transformation?
What is domain and gateway node?
What you know about transaction control transformation?
In development project what is the process to follow for an etl developer from day1
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is an Integration service in Informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is unit testing?tell me proceedure
How we can use union transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
