suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
Answer Posted / shankar
SQ---->AGR---->RTR---->TGT
SEQ--->RTR
1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
What is the function of aggregator transformation?
What is the need of etl tools?
What is the need for an etl tool?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can you define user defied event?
How many number of sessions can one group in batches?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to do unit testing in informatica? How to load data in informatica ?
How do you change a non-reusable transformation to reusable transformation?
How many ways are there to create ports?
Why union transformation is an active transformation?
How to update source definition?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.