What is informatica?
What exactly are the practical uses in real world
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 |
How to do unit testing in informatica? How to load data in informatica ?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Implementation methodology
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the challenges you have faced in your project?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
When to use normalization transformation other than cobol source?
why we use stored procedure transformation?
What is a look up function? What is default transformation for the look up function?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?