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
- 10040 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
Write the different tools in the workflow manager?
How to join three sources using joiner?
in reporting we add some new objects,how we get the count of the newly added objects to the report
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is an active transformation?
Separate from a database, an information bazaar, and an information stockroom?
tell me the rules and responsblites in our project(my project is development)
How does a sorter cache works?
What is meant by incremental aggregation?
Describe the impact of several join conditions and join order in a joiner transformation?
Explian the Process of deployment groups in informatica
How to differentiate between the active and passive transformations?
How to configure mapping in informatica?
What is data transformation manager process?
What are the differences between joiner transformation and source qualifier transformation?
