suppose we have 1 to 10 records.In router transformation we
had given two condition
A>= 5
A<=5
then what will be the output?

Answers were Sorted based on User's Feedback



suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<..

Answer / srinivas

A>=5 ---> target1 output is 5th to 10th record
A<=5 ---> target2 output is 1st to 5th record

Is This Answer Correct ?    16 Yes 4 No

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<..

Answer / mike

If you create two groups in the router transformation and
you want to load the records in to two target tables then

src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output


correct me if i was wrong

Is This Answer Correct ?    7 Yes 6 No

Post New Answer

More Informatica Interview Questions

how to create user defined function (udf) in informatica

0 Answers   Informatica,


Write the program through which the records can be updated?

0 Answers  


How to call shell scripts from informatica?

0 Answers  


What is facttable granularity?

2 Answers  


i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,






What are the scheduling options to run a sesion?

2 Answers  


What is aggregator transformation in informatica?

0 Answers  


Which kind of index is preferred in DWH?

3 Answers  


in which situations do u go for sequence generator ?

2 Answers   TCS,


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,


In Which scenario did u used Incremental loading?

2 Answers  


By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,


Categories