Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeepbabu
Represents the source record set queried by the integration server/service.It is mandatory in the mapping when the source is relational or flat files.And it is a Active transformation.
source qualifier contain some properties is given bellow:
1>Sql query:It is generated by integration server by default and It contain Sql override,used to modify the default select Statmets...
2>user defined join:It is content of WHERE Clause to join separate Source
3>source filter:Filter applied to source Records..
4>Number of sorted ports:used to sort input ports.When we are using sorted ports the Powercenter add ports by default'Orderby'.BY default sorted ports are Zero
5>Select Distinct:selct unique values only
6>pre sql:The sql database before reads the source data
7>post sql:The sql database after write the data in to target table..
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What are the differences between source qualifier and joiner transformation?
Performance tuning in UNIX for informatica mappings?
How can we create index after completion of load process?
How can we remove the duplicates from flat file source?
What is powercenter on grid?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to load last n records of file into target table - informatica
Which version configuration tool used in ur project?
how tokens will generate?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a difference between complete, stop and abort?
Differences between connected and unconnected lookup?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What differs when we choose the sorted input for aggregator transformation?
