PREVIOUS

What is default join that source qualifier provides?

Inner equi join.


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.


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.


Describe two levels in which update strategy transformation sets?

what is default source option for update strategy transformation?

Data driven.


What is data driven?

The informata 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.

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.

NEXT