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
- 6958 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 are cubes and olap cubes?
what is Forward,Reverse and Re_engineering?
What are your responsibilities as an etl tester?
how would u estimate the size of Aggregator transform data and index cache?
Explain what is etl process? How many steps etl contains explain with example?
What are the names of the layers in etl?
how many maximum session supports to multiload in teradata ??
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how do u extract data from different data sources explain with an example?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
how do u implement configuration management in Informatica?
Is hadoop a etl tool?
When do we analyze the tables? How do we do it?
