Interview Questions

1) what is the target load order?

You specify the target load order based on source qualifiers in a mapping.if u have the multiple source qualifiers connected to the multiple targets you can designate the order in which informatica server loads data into the targets.

2) what is default join that source qualifier provides?

Inner equi join.

3) what are the difference between joiner transformation and source qualifier transformation?

You can join heterogeneous data sources in joiner transformation, which we cannot achive in source qualifier transformation.You need matching keys to join two relational sources in source qualifier transformation.where you doesn’t need matching keys to join two sources.Two relational sources should come from same data source in source qualifier.You can join relational sources, which are coming from different sources in source qualifier.You can join relational sources which are coming from different sources also.

4) what is update strategy transformation?

Whenever you create the target table whether you are store the historical data or current transaction data in to target table.


5) Describe two levels in which update strategy transformation sets?

1) using the update strategy Transformation In the Mapping.

2) Using the Target table option at the session.


6) what is default source option for update strategy transformation?

Data driven.

7) What is data driven?

The information server follows instructions coded into update strategy transformations with in the session mapping determine how to flag records for insert,update,delete or reject if u do not choose data driven option setting , the informatica server ignores all update strategy transformations in the mapping.

8) what are the options in the trarget session of update strategy transformation?

Insert

Delete

Update

Update as update

Update as insert

Update else insert

Truncate table.


9) Difference between the source filter and filter?

Source filter is filtering the data only relational sources. Where as filter transformation filter the data any type of source.

10) what is a tracing level?

Amount of information sent to log file.



-- What are the types of tracing levels?

Normal,Terse,verbose data,verbose intitialization.



--Expalin sequence generator transformation?



-- can you connect multiple ports from one group to multiple transformations?

Yes


Freqently Asked Questions:

FaQ1 FaQ2 FaQ3 FaQ4 FaQ5 FaQ6 FaQ7 FaQ8 FaQ9 FaQ10 FaQ11 FaQ12 FaQ13 FaQ14 FaQ15 FaQ16 FaQ17 FaQ18 FaQ19 FaQ20 FaQ21