1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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?

Question Posted / ram

Answers were Sorted based on User's Feedback



Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having m..

Answer / 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

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having m..

Answer / siddiq

First U will create sequence number for the 3records
using sequence generator t/r then U can create an
expression t/r in that use the mod function like

mod(seqno,3)=1
mod(seqno,3)=2
mod(seqno,3)=0

then u will get the resulr

Is This Answer Correct ?    3 Yes 0 No

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having m..

Answer / 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

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having m..

Answer / balaganesh

Using Sequence Generator and router we can achive this
problem.

In Seq Gen:
1) Set current value is 1 and end value is 3. Also, enable
the recycle option.

Now using router you can separate the records into target.

Is This Answer Correct ?    2 Yes 2 No

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having m..

Answer / mural

hi srinivas this is lenthy process it is not possible

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

Hi, Lookup() is what kind of join ?

6 Answers   Satyam,

what are the different Reporting and ETL tools available in the market?

3 Answers  

What is data cleaning?

0 Answers  




Explain about enterprise scalability and roi of data integration suite?

0 Answers  

Is hadoop a etl tool?

0 Answers  

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  

what is a test load?

3 Answers  

Can u access a repository created in previous version of Informatica?

0 Answers  

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

how to load the data to fact table?

0 Answers  

For more ETL Interview Questions Click Here
Categories