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
- 8621 Views
- I also Faced
- E-Mail Answers
Answer Posted / jitendra
We can clearly understand that we need a Router
transformation to route or filter source data to the three
target tables. Now the question is what will be the filter
conditions. First of all we need an Expression
Transformation where we have all the source table columns
and along with that we have another i/o port say seq_num,
which is gets sequence numbers for each source row from the
port NextVal of a Sequence Generator start value 0 and
increment by 1. Now the filter condition for the three
router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table,
MOD(SEQ_NUM,3)=2 connected to 2nd target table,
MOD(SEQ_NUM,3)=0 connected to 3rd target table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the session parameters? How do u set them?
Explain the use lookup tables and Aggregate tables?
What are the differences between sql override and update override?
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?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Explain the key challenges that you face while performing etl testing.
What is fact? What are the types of facts?
What do you understand by the term ‘transformation’?
What is virtual Data Warehousing?
What is Data Vault???
Mention few test cases and explain them?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain and compare etl & manual development?
what is session partitioning?
What is data cleaning?
