Informatica Data Warehousing Interview Preparation Guide
Download PDF
Add New Question

Informatica Data Warehousing Frequently Asked Questions in various Informatica Data Warehousing Interviews asked by the interviewer. So learn Informatica Data Warehousing with the help of this Informatica Data Warehousing Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any Informatica Data Warehousing Interview Question or answer by the comment feature available on the page.

64 Informatica Data Warehousing Questions and Answers:

1 :: If two relational tables are connected to SQ Trans, what are the possible errors it will be thrown?

The only two possibilities as of I know is

Both the table should have primary key/foreign key relation ship
Both the table should be available in the same schema or same database
Post Your Answer

2 :: What is a command that used to run a batch?

pmcmd is used to start a batch.
Post Your Answer

3 :: How to stop a batch?

By using server manager or pmcmd.
Post Your Answer

4 :: What is EDW?

EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.

this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department.

Advantages of having a EDW:

1. Golbal view of the Data
2. Same point of source of data for all the users acroos the organization.
3. able to perform consistent analysis on a single Data Warehouse.

to over come is the time it takes to develop and also the management that is required to build a centralised database.
Post Your Answer

5 :: What is the Difference between static cache and dynamic cache?

Static cache:
We can not insert or update the cache.

Dynamic cache:
We can insert rows into the cache as we pass to the target.
Post Your Answer
Add New Question