Informatica is a software development company.Informatica was founded in 1993. Informatica is headquarters in Redwood City, California. The main Core Products are Data Integration and Enterprise Cloud Data Management
What do you mean by Enterprise Data Warehousing?
What the difference is between a database, a data warehouse and a data mart?
What is the difference between a repository server and a powerhouse?
What is the benefit of partitioning a session?
How are indexes created after completing the load process?
Explain sessions. Explain how batches are used to combine executions?
How many number of sessions can one group in batches?
Explain the difference between mapping parameter and mapping variable?
Briefly explain the Aggregator transformation?
Describe Expression transformation?
What do you mean by filter transformation?
What is Joiner transformation?
What is Lookup transformation?
How Union Transformation is used?
What do you mean Incremental Aggregation?
What is the difference between a connected look up and unconnected lookup?
Briefly define reusable transformation?
What does update strategy mean, and what are the different option of it?
What is the scenario which compels informatica server to reject files?
What are the prerequisite tasks to achieve the session partition?
Which files are created during the session rums by informatics server?
Briefly define a session task?
What is standalone command task?
What is meant by pre and post session shell command?
How can one identify whether mapping is correct or not without connecting session?
Explain the use of aggregator cache file?
Briefly describe lookup transformation?
What does role playing dimension mean?
How can repository reports be accessed without SQL or other transformations?
What are the types of metadata that stores in repository?
Explain the code page compatibility?
How can you validate all mappings in the repository simultaneously?