Define filter transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how can i invoke pmcmd in command line prompt

1 Answers  


how many ways can we implement SCD2?

4 Answers   IBM, TCS,


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


How can you define user defied event?

0 Answers  






Explian the Process of deployment groups in informatica

0 Answers   Informatica,


What is fact table? Explain the different kinds of facts.

0 Answers  


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


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,


When do you use mapping parameters? (In which transformations)

1 Answers  


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


Categories