Informatica Data Warehousing Interview 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

Is This Answer Correct?    8 Yes 0 No

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

pmcmd is used to start a batch.

Is This Answer Correct?    5 Yes 0 No

3 :: How to stop a batch?

By using server manager or pmcmd.

Is This Answer Correct?    4 Yes 0 No

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.

Is This Answer Correct?    1 Yes 0 No

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.

Is This Answer Correct?    2 Yes 0 No