Data Warehouse Developer Interview Questions and Answers – Page 12

What is use of custom library?

Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.

How can u recognise whether or not the newly added rows in the source r gets insert in the target ?

What is a basic difference between having and where clause?

Which transformation should u need while using the cobol sources as source defintions?

Why oracle is the best database?

Can we put all the logic in the trigger?

What r the connected or unconnected transforamations?

What is record group ?

To provide support for Mainframes source data,which files r used as a source definitions?

How does the server recognise the source and target databases?

What is the difference between detect alias and detect context?

Can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

What is the difference between OLAP and datawarehosue?

What r the tasks that source qualifier performs?

Can any body write a session parameter file which will change the source and targets for every session. i.e different source and targets for each session run.

How do you decide whether you need ti do aggregations at database level or at Informatica level?

Can you suggest me good author for Hyperion in data warehousing ?

What is Informix Binary Large Object?

How the form sub function is implemented?

What are the common problems developers face while ETL development

What is parameter file?

What is difference between IIF and DECODE function

Where should U place the flat file to import the flat file defintion to the designer?

What is the difference between User And versatile user?

What is the difference between ODS and OLTP

How to move the mapping from one database to another?

What r the mapings that we use for slowly changing dimension table?

What are the methods for creating reusable transforamtions?

Diff between informatica repositry server & informatica server