Informatica interview questions – page 9

What is difference between IIF and DECODE function

What is data merging, data cleansing, sampling?

If you have four lookup tables in the workflow. How do you troubleshoot to improve performance?

What are various types of Aggregation?

What is Partitioning ? where we can use Partition? wht is advantages? Is it nessisary?

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

When we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files...

How can i transform row to column?

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?

Can i use a session Bulk loading option that time can i make a recovery to the session?

Diff between informatica repositry server & informatica server

What r the types of maping wizards that r to be provided in Informatica?

What r the types of groups in Router transformation?

Can u generate reports in Informatcia?

What is a source qualifier?-

Can i run the mapping with out starting the informatica server?

Can we lookup a table from a source qualifer transformation-unconnected lookup

How can you access the remote source into your session?

What r the reusable transforamtions?

What are the unsupported repository objects for a mapplet?

Why dimenstion tables are denormalized in nature ?

In a scenario I want to change the dimensions of a table and normalize the renormalized table which transformation can I use?

If the workflow has 5 session and running sequentially and 3rd session hasbeen failed how can we run again from only 3rd to 5th session?

Define maping and sessions?

How to get two targets T1 containing distinct values and T2 containing duplicate values from one source S1.

How to use the unconnected lookup i.e., from where the input has to be taken and the output is linked? What condition is to be given?

To achieve the session partition what are the necessary tasks you have to do?

Why is meant by direct and indirect loading options in sessions?