my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
Answer Posted / santosh kumar sarangi
1.first sort the data with sorter t/r as ID key column and
create below port in exp transformation
var2= var1
id
var1=id
rec_count=iff(var1=var2,rec_count+1,1)
2.Give all the port to router t/r and give the filer
condition as below
rec_count=1 then to first target
default to 2nd target
Let me know if any things is wrong.
Thanks & Regards
Santosh Kumar Sarangi
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is expression transformation?
draw informatica architecture 8.6 ?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Mention a few design and development best practices for informatica?
Target increases every day even though no new record was inserted
What if the source is a flat-file?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the differences between source qualifier and joiner transformation?
What is workflow? What are the components of workflow manager?
How to generate sequence numbers without using the sequence generator transformation?
How to extract sap data using informatica?
Define Pmrep command?
what is index?how it can work in informatica
what are the Methods For Creating Reusable Transformations?
what is Active lock explain