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
- 30658 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
How do you set a varible in incremental aggregation
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What do think which one is the better joiner or look up?
How to differentiate between the active and passive transformations?
What are the new features of informatica 9.x in developer level?
explain abt ur project architecture?
What is meant by target load plan?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How an expression transformation differs from aggregator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the advantage of informatica?
Explain pmcmd command usage in informatica
What is mapplet in informatica?
What are the differences between joiner transformation and source qualifier transformation?
