What is informatica?
What exactly are the practical uses in real world

Answers were Sorted based on User's Feedback



What is informatica? What exactly are the practical uses in real world..

Answer / niharika panda

Informatica is an ETL tool used in DWH concept.
It keeps historical data. So all those organizations who wants
to keep their all data i.e. updated and historical too(not
only to update data and deleting the old data) can use it.

Is This Answer Correct ?    5 Yes 3 No

What is informatica? What exactly are the practical uses in real world..

Answer / jagadeesh gaddam

Informatica is an etl toll .it loads the data from various oltps like homogenius as well as hetrogeniuse.based on this loadig  data we can genarate the reports what we exactly want for our business development and anyalise the business and take the right decissions 

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the maplet?

0 Answers   Informatica,


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  






I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


What is predefined event?

1 Answers  


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  


in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


Why filter transformation is an active one?

0 Answers  


Categories