How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
Answer Posted / p1khatri
using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2
I hope this'll work
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Write the different tools in the workflow manager?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain the tuning lookup transformation - informatica
What are the designer tools for creating transformations?
Informatica settings are available in which file?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How you can differentiate between connected lookup and unconnected lookup?
COM components can be used in Informatica
Why union transformation is an active transformation?
How can you validate all mappings in the repository simultaneously?
Explain incremental aggregation in informatica
What are the differences between source qualifier and joiner transformation?
How an expression transformation differs from aggregator transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?