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
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is persistent lookup cache?
Explain sessions and how many types of sessions are there?
What is source qualifier transformation in informatica?
What is substr in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what are 3 tech challenges/ common issues you face?
can you please explain me pre session and post session options?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What the difference is between a database, a data warehouse and a data mart?
Describe the impact of several join conditions and join order in a joiner transformation?
What is Index Caches size?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
In how many ways we can create ports?
Design a mapping to load the cumulative sum of salaries of employees into target table?
