Interested to Buy Any Domain ? << Click Here >> for more details...
100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
- 3 Answers
- 11481 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / chandra
SQ--->EXP-->ROUTER---->TARs
In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is olap (on-line analytical processing?
How can we remove the duplicates from flat file source?
How you can differentiate between connected lookup and unconnected lookup?
What are the tasks that can be performed using sq?
What are data-driven sessions?
can we override a native sql query within informatica? How do we do it?
What is different between the data warehouse and data mart?
can we override a native sql query within informatica? Where do we do it?
How to implement security measures using repository manager?
Design a mapping to load a target table with the following values from the above source?
What are the tasks that source qualifier perform?
what is the Default Source Option For Update Strategy Transformation?
What is an active transformation?
What do mean by local and global repository?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
