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

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,


WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  


SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  


HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,






How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


How to use Normalizer transformation?

2 Answers  


What is IQD file?

1 Answers  


How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,


How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  


We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  


Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  


Categories