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

Parameter and variable differences

0 Answers  

what is parameter file?

1 Answers   Cap Gemini,

What is rank transformation?

0 Answers  

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  




can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

How the facts will be loaded? explain

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories