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

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


what is INFORMATICA TESTING process

0 Answers  


Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  


Enlist the advantages of informatica.

0 Answers  






IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  


How to eliminate duplicates from flat file..what is the procedure

4 Answers  


how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,


what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,


How to use Normalizer transformation?

2 Answers  


Explain the informatica workflow?

0 Answers  


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


Categories