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
In informatica workflow manager, how many repositories can be created?
Can we create multiple integration service on single repository?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what is size of u r database?
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.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the unconnected lookup syntax?
What is standalone command task?
How many dimensions are there in informatica?
How does a sorter cache works?
How can we delete duplicate rows from flat files?
What are active and passive transformations?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
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?