Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 31014 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh araveti
source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the various types of transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
If informatica has its scheduler why using third party scheduler?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the different kinds of facts.
What are mapplets? How is it different from a Reusable Transformation?
Different sorts of metadata that stores in the storage facility?
lookup transformation with screenshots
What are the differences between a connected lookup and unconnected lookup?
How can we create index after completion of load process?
Which transformation should we use to normalise the COBOL and relational sources?
How an expression transformation differs from aggregator transformation?
What is the use of source qualifier?
What is the function of union transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
