How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28103 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
Mention a few design and development best practices for informatica?
If informatica has its scheduler why using third party scheduler?
What is different between the data warehouse and data mart?
how to load dimension table and fact table. plz tell me the steps.
Explain informatica architecture - version 8 / 9
How to create Target definition for flat files?
What is an Integration service in Informatica?
What is the benefit of session partitioning?
explain abt ur project architecture?
While migrating the data from one environment to another environment how would you manage the connections?
What are the different types of olap? Give an example?
What are the different types of repositories created using informatica?
Explain sessions. Explain how batches are used to combine executions?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain in detail about scd type 1 through mapping.
