How to extract original records at one target & Duplicate
records at one target?
Answer Posted / shankar
First Pipeline:
SQ--Sort---Tgt1
Second Pipeline:
SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.
Use target load plan while u run the session...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the popular informatica products?
What are the advantages of informatica?
What is the sql query overwrite in source qualifier in informatica
Explain dynamic target flat file name generation in informatica
Did u used latest transformations of 8.6.0? for what?
What are the tuning techniques you applied during your last project
What is a surrogate key?
How do you convert single row from source into three rows into target?
What all join we can perform in LOOKUP transformation?
What are the different lookup cache(s)?
Why union transformation is an active transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to load last n records of file into target table - informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?