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 Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1162


What is the function of look up transformation?

761


What is a code page?

799


During the running session, output files are created by informatica server. Enlist few of them.

625


without table how to come first record only in oracle?

1940






what is the size ur source like(file system or database)? how many record daily come u r banking project?

1826


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1618


How many ways are there to do 'remove duplicate records in informatica'?

670


How to call shell scripts from informatica?

662


Why update strategy and union transformations are active? Explain with examples.

814


Enlist the advantages of informatica.

728


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

1678


Is it possible to use a client with different version than that of its Informatica server?

739


What is a node in Informatica?

719


What are the advantages of informatica?

661