Enlist few areas or real-time situations where informatica is required.


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

Post New Answer

More Informatica Interview Questions

What is DTM process?

4 Answers  


What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,


Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?

4 Answers  


i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  


Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,






What is the different lookup cache(s)?

0 Answers  


What are different types of transformations available in informatica?

0 Answers  


Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,


How to load a Dimension ? and how to load a fact table?

0 Answers  


How can you increase the performance in joiner transformation?

0 Answers  


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,


I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,


Categories