What is informatica?
What exactly are the practical uses in real world
- 2 Answers
- 5093 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
write a query to get maximum salary from the employers table without duplicates....kindly help me
Explain the difference between a data warehouse and a data mart?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is Datadriven?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What is the reusable transformation?
What is hash partition?
How to load a Dimension ? and how to load a fact table?
How to retrieve last two days updated records?
Teradata 
