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
- 9272 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 use union transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is complex mapping?
What are the different clients of powercenter?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is fact table? Explain the different kinds of facts.
pmscmd startworkflow -sv
What are the types of data warehouses?
How can we use mapping variables in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is different between the data warehouse and data mart?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can we get 1st record through Informatica(without sequence number).
Briefly define a session task?
tell me about your project functionality
