i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow

Answers were Sorted based on User's Feedback



i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / vani

Can it be done in this way....

1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.

If i am wrong please tell me....

Is This Answer Correct ?    27 Yes 4 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / sree

1. drag source and targets in to mapping designer work space
2. from t/r devoloper take sequence genarato t/r,exp t/r
and router t/r.
3. in seqg t/r give startvalue 1 ,increment by 1
give netval to a newpor in exp t/r
4. drag all ports of sq to exp in addition to newport
5. in router t/r create one group name as odd
give condetion mode(newport/2)!=0
6. give from group odd to t1
and defoult to t2.

Is This Answer Correct ?    6 Yes 0 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / anand kumar

We can do this in the following.

Take the sequence generator t/r
set the properties like
Start value 1
End value 2
and also Enable cycle option

connect the nextval port to the router T/r
port "SGTNO"(created by you) and also connect the ports
from source qualifier to the router t/r

Now given the first condition like
SGTNO=1 then go to first target
otherwise go to second target(here no need to mention the
second condition).

If I went wrong, please let me know

Thanks
Anand Kumar

Is This Answer Correct ?    4 Yes 1 No

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 an..

Answer / sreekar

Hi,

Steps:-

1.Load ur source table into source analyzer.

2.generate the target tables.

3.in the maping designer take 2 filter transformations and
write these queries in each of the filter transformations

for even no of records:- select * from <tablename> where
(rowid,1) in (select rowid, mod(rownum,2) from <tablename>)

for odd no of records:- select * from <tablename> where
(rowid,0) in (select rowid, mod(rownum,2) from <tablename>)\

4. connect the output ports of this transformation to their
respective output tables.

Note:-
send your responses to suriaslesha_sreekar@yahoo.co.in

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Informatica Interview Questions

How can we delete duplicate rows from flat files?

0 Answers  


Where are the source flat files kept before running the session?

0 Answers   Informatica,


in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  






Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


What is the Difference between DSS & OLTP?

5 Answers  


Mention few advantages of router transformation over filter transformation.

0 Answers  


What is a unit Testing?

1 Answers  


S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,


What is rank index in rank transformation?

0 Answers  


What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  


Categories