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
- 8386 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 pmrep command?
explain the methodology of Data Warehousing?(Polaries)
what is session partitioning?
Explain about hash partitioning?
what is Forward,Reverse and Re_engineering?
What is a materialized view log?
what is granularity in Data ware House?
What are your responsibilities as an etl tester?
Mention few test cases and explain them?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
how many maximum session supports to multiload in teradata ??
Explain etl?
what are the reports developed in sap bw project and what is the requirement for developing it?
What are the ETL Testing Operations?
What is data modeling and data mining?
