how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What is the use of transformation?
how to load rows into fact table in data warehouse
What are the uses of etl tools?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the types of data warehouses?
Did u used latest transformations of 8.6.0? for what?
Enlist the advantages of informatica.
What is the different lookup cache(s)?
Which version configuration tool used in ur project?
Explain pmcmd command usage in informatica
What is the surrogate key?
Please let me know how to make encryption and decryption with example?
What is meant by pre and post session shell command?
What do think which one is the better joiner or look up?
What is the difference between STOP and ABORT options in Workflow Monitor?