1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

can we see default group,when we use router?if yes how?

Question Posted / prasuna

Answers were Sorted based on User's Feedback



can we see default group,when we use router?if yes how?..

Answer / murthy

Yes..we can use Default group..all the records that doesnt
meet the conditon comes to this default group..just connect
it to any other transforemation and use it acc to ur reqmnt.

Is This Answer Correct ?    11 Yes 1 No

can we see default group,when we use router?if yes how?..

Answer / sweta kedia

Yes we can see the default group. Wen we add router, there r
no groups. Wen we add any group,then a default group is also
added.We can add conditions for this group according to our
requirement. If we do not give any conditions,all the
records that doesnt meet the conditon comes to this default
group. Just connect it to any other transformation and use
it acc to ur reqmnt.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

How to use pmcmd utility command?

0 Answers  

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,




Which kind of index is preferred in DWH?

2 Answers  

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories