Thursday, April 11, 2019

Source Qualifier Transformation

Source Qualifier Transformation is Connected and Active transformation. When ever we drag our source to mapping area by default source qualifier will be generated automatically. Its because the sq converts the other data types to informatica compatible or native data types. This source qualifier data types should not be altered at any moment.

Sq can perform many tasks like
- It can join two to more tables from same database by using option from   properties tab 'user defined join'.
- It can filter rows from source by using 'source filter' option from properties   tab. 
- We can sort the data by adding order by clause to 'sql query' option from   properties tab. 
- It can remove duplicate by selecting distinct option from properties tab. 

Creating Source Qualifier Transformation :-

- Click Transformation -> Create
- Select the Source Qualifier transformation.
- Enter a name for the transformation
- Click on create

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Date Functions in SQL

Select Getdate() as CurrentDate; Select Getdate() -1 PreviousDate; Select Getdate() +1 NextDate; Select DATEADD(dd,1,getdate()) as NextDate;...

  • Analytical Functions
    The functions SUM, COUNT, AVG, MIN, MAX are the common aggregate functions the result of which does not depend on the order of the records....
  • Update Strategy Transformation
    Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
  • Session parameters & Session variables
    Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...