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
- 8243 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
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is staging area referring to?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What are the differences between sql override and update override?
What is virtual Data Warehousing?
how do u set partition points in the mapping?
What is a staging area? What is the purpose of a staging area?
What is lookup table in etl testing?
What is abap? What are idocs?
flat filevalidation in informatica
what are the concerns of OLTP and DSS systems?
what is a worklet?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain do we need an etl tool?
