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
How we can create indexes after completing the loan process?
Enlist the advantages of informatica.
How to handle decimal places while importing a flatfile into informatica?
State the differences between sql override and lookup override?
How to open an older version of an object in the workspace?
Explain constraint based loading in informatica
What is meant by incremental aggregation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Informatica settings are available in which file?
What are the new features of informatica 9.x developer?
Differentiate between router and filter transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Global and Local shortcuts. Advantages.
How do we call shell scripts from informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?