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
- 8444 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
where we cannot use sorter Transformation. if we use then we will not get correct data?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what is pmrep command?
what make u disappointmnets in u r career
how do u set partition points in the mapping?
can cubes contain measures ?
Compare etl & elt?
Explain do we need an etl tool?
how would u estimate the size of Lookup transform data and index cache?
what do u do when DB time takes more?in sap bi
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain about etl data integration software?
how do u extract data from different data sources explain with an example?
What is meant by incremental load?
What are the modules in Power Mart?
