Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answer Posted / anu
take sequence annd router t/r 's
connct nextval port to router
create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2
this is applicable to above six source rows only
this is my second logic
tell me any corrections
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is enterprise data warehousing?
How to load a Dimension ? and how to load a fact table?
How do you handle two sessions in Informatica
What are the tasks that source qualifier perform?
Differences between version 7.x and 8.x.
What is data transformation manager process?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Can anyone tell me the new features in Informatica 9 Version?
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.
What are the different components of powercenter?
In warehouses how many schemas are there?
How can we remove the duplicates from flat file source?
How can we update a record in the target table without using update strategy?
How can we use batches?