Interested to Buy Any Domain ? << Click Here >> for more details...
How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 29700 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a pre-defined event and user-defined event?
What is a grid in Informatica?
What do mean by local and global repository?
Explain what are the different versions of informatica?
Can u generate reports in Informatica?
what is the size of your data warehousing?
What is informatica powercenter repository?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the meaning of up gradation of repository?
Quickly characterize reusable change?
How do you convert single row from source into three rows into target?
What are the guidelines to be followed while using union transformation?
What is joiner transformation?
