How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / vaas
Hi All,
One tbl has duplicate values means it does not has PK.In
this case can we use dynamic lookup.
Pl let me know, on vaas31@yahoo.in
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Informatica settings are available in which file?
How to create a non-reusable instance of reusable transformations?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain scd type 3 through mapping.
What is the procedure for creating independent data marts from informatica 7.1?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
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?
What is session task and command task?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between a connected look up and unconnected lookup?
Define joiner transformation?
Can we override a native sql query within informatica?
What is substr in informatica?
How do you take back up of repository?