Interested to Buy Any Domain ? << Click Here >> for more details...
Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
- 5 Answers
- 8434 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
sequence generator>expression trans>router>targets
in router create 2 userdefined groups, 1 default group.
ie total 3 o/p groups
group1 condtion . mod(nextval,3)=0
group2 condtion . mod(nextval,3)=1
group3 condtion . mod(nextval,3)=2
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is the difference between cardinality and Nullability?
what make u disappointmnets in u r career
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Explain do we need an etl tool? When do we go for the tools in the market?
What is a staging area? What is the purpose of a staging area?
What are the steps involved in etl process?
What are three tier systems in etl?
What is data cleaning?
What is abap? What are idocs?
How can we use external procedural logic in informatica?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the etl testing operations includes?
How many types of transformations supported by sorted input?
what are the production issues in datastage?
how do u extract data from different data sources explain with an example?
