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
pmscmd startworkflow -sv
What is the function of look up transformation?
What is a code page?
During the running session, output files are created by informatica server. Enlist few of them.
without table how to come first record only in oracle?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
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
How many ways are there to do 'remove duplicate records in informatica'?
How to call shell scripts from informatica?
Why update strategy and union transformations are active? Explain with examples.
Enlist the advantages of informatica.
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
Is it possible to use a client with different version than that of its Informatica server?
What is a node in Informatica?
What are the advantages of informatica?