Write the unconnected lookup syntax and how to return more than one column.

1058

What is target designer and target load order?

1057

Explain the types of lookup transformation?

984

Explain the shared cache and re-cache?

1060

How to generate or load values in to the target table based on a column value using informatica etl tool.

1025

Explain the difference between a data warehouse and a data mart?

1007

Which development components of informatica have the highest usage?

995

What are the different types of olap? Give an example?

984

How to do unit testing in informatica? How to load data in informatica ?

1053

what is the Default Source Option For Update Strategy Transformation?

1174

design of staging area?

1970

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7326

Tell me about MD5 functions in informatica

882

What is persistent lookup cache?

975

what are the Methods For Creating Reusable Transformations?

1109