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

What is an expression transformation?

0 Answers  


What are the data movement modes in informatcia?

3 Answers  


When to use normalization transformation other than cobol source?

2 Answers  


Design time, run time. If you don't create parameter what will happen

0 Answers  


How would you copy the content of one repository to another repository?

0 Answers  






Scheduling properties,whats the default (sequential)

0 Answers  


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


WAT IS TEXT LOAD?

3 Answers   Wipro,


3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


What are the types of caches in lookup?

0 Answers  


Categories