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
- 29549 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 is an Integration service in Informatica?
How to create a non-reusable instance of reusable transformations?
During the running session, output files are created by informatica server. Enlist few of them.
What are data-driven sessions?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is informatica worklet?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain pmcmd command usage in informatica
How can one identify whether mapping is correct or not without connecting session?
What is sequence generator transformation in informatica?
What is meant by a domain?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Differentiate between a database and data warehouse?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
