One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?

Answer Posted / sanjay

Sq-->Expression-->Router-->Target
| |
| v
v grp1--> col=1
mod(col,3) grp2--> col=2
Default

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In informatica workflow manager, how many repositories can be created?

771


Can we create multiple integration service on single repository?

693


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1467


what is size of u r database?

1841


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.

624






While importing the relational source definition from the database, what are the metadata of source that will be imported?

778


Write the unconnected lookup syntax?

646


What is standalone command task?

695


How many dimensions are there in informatica?

616


How does a sorter cache works?

558


How can we delete duplicate rows from flat files?

731


What are active and passive transformations?

639


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2129


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

529


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5552