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
- 10244 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
Make a note of the quantity vaults made in informatica?
What is a joiner transformation and why it is an active one?
What is the function of union transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
How to load a Dimension ? and how to load a fact table?
Design time, run time. If you don't create parameter what will happen
What is Data Caches size?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the different lookup cache(s)?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the new features of informatica 9.x at the developer level?
what is song in infrmatica...?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the advantages of using informatica as an etl tool over teradata?
Enterprise data warehouse your projects phase by phase explain?
