Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9544 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
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
How we can create indexes after completing the load process?
How can repository reports be accessed without sql or other transformations?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Define mapplet?
What is a pre-defined event and user-defined event?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you take back up of repository?
How can we use batches?
tell me about your project functionality
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
If informatica has its scheduler why using third party scheduler?
What are active transformations.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
