Etl interview questions – page 2

Can we override a native sql query within Informatica? Where do we do it? How do we do it?

How do we call shell scripts from informatica?

What is Informatica Metadata and where is it stored?

What are snapshots? What are materialized views & where do we use them? What is a materialized view lo

What are the modules in Power Mart?

What are advantages of NLS function? where we can use that one? explain briefly?

Lets suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values?

What is a staging area? Do we need it? What is the purpose of a staging area?

At the time of installation i had not choosen that NLS option , now i want to use that options what can i do ? to reinstall that datastage or first uninstall and install once again ?

What are the different Lookup methods used in Informatica?

Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica?

Is there any way to read the MS Excel Data's directly into Informatica?Like IS there any Possibilities to take excel file as target?

How to determine what records to extract?

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

Can we lookup a table from source qualifier transformation. ie. unconnected lookup

What is the difference between Inprocess and Interprocess ?

Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)

Can we have two reports running parallely and both the reports sharing the same internal table for processing the data?

How many ways to deploy the ssis package ?

Slowly changing dimensions in SSIS ? and how many types what is the difference between them ?

Transform functionalities

End to end migration services.

Lookup / Join / Merge

Remove duplicates

What is datawarehouse