If I have router with 10 records, if the condition doesn’t
satisfy the records will pass to the default group,then
where can we see that records and where that records will store?

Answers were Sorted based on User's Feedback



If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the d..

Answer / sravan

If you want to see those records, u have to connect default
group to some other target table. I think, this is the
only way, we can see those records.

Is This Answer Correct ?    12 Yes 0 No

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the d..

Answer / srikanth

yeah,its correct sravan

Is This Answer Correct ?    0 Yes 0 No

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the d..

Answer / gsr

All the rows which do not meet any of the conditions are
passed to the default group. If we dont need the rows in
the default group we can drop them by not connecting them
to another transformation or a target in the mapping. If we
need them we can connect them to another transformation or
a target in the mapping.

Is This Answer Correct ?    1 Yes 1 No

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the d..

Answer / abhishek

Hi Sarvan,
Partialy u r rite but no need to go for target ,It will
bydefault go for default group in router so u can see from
there
this is the main diff between router and joiner

Regards
Abhishek

Is This Answer Correct ?    1 Yes 12 No

Post New Answer

More Informatica Interview Questions

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


What is Datadriven?

2 Answers   Informatica,


How/where can i install Informatica software with oracle or teradata as database

0 Answers  


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,






normalizer transformation

3 Answers   CTS,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


can a port in expression transf be given the name DISTINCT

3 Answers  


How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,


What are the types of metadata that stores in repository?

2 Answers  


Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  


Categories