How can i send first half of the records to one target and
Remaining to other target?
Answer Posted / mukunda
we have to follow the follwing pipe line
seq--|
SOURCE-->SQ-->EXP-->STOREPROCEDURE-->EXP--->ROUTER---->T1
|------>T2
Using store procedure we can count the total no of rows.
Using sequence genater we have to create the assign the
value to each row. Then find the max rowid using the srore
Procedure t/r. Then this result value store as 'n'. And
the wrire the conditon in router tranformation.
GROUP1--->N<=N/2--->connected to Target1
GROUP2--->N>=N+1/2--->Connected to Target2
*FOR exaple the source table is containg 99 records.
Using the store procedure we can find the count value n as
99.
Conditoin1-->N<=N/2(=44)44 records store in to target1.
Condition2--->N>=N+1/2(=45)-->45 Records store in to the
target2.
If you have any quires plese ask. mukunda.velluri@gmail.com
Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Informatica Checkpoints
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the function of union transformation?
What are Dimensional table?
Please let me know how to make encryption and decryption with example?
How to partition the Session?
How to extract the informatica rejected data?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you migrate data from one environment to another?
Differentiate between a database and data warehouse?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
list out all the transformations which use cache?
What is a connected transformation?
What is joiner transformation in informatica?
How to create the source and target database connections in server manager?