why we use source qualifier transformation?
Answer Posted / vidya acharya
1. SOURCE QUALIFIER TRANSFORMATION represents the rows that informatica powercenter server reads from RELATIONAL or FLAT FILE SOURCE when it runs the session.
2. When relational or flat file source definition is added to the mapping, informatica server creates the SQ by default. thus, its a default transformation in informatica.
3. Any source(relational/flat file) cannot be read without using SQ as it converts the database specific datatype to informatica native datatype.
4. For relational sources, additional properties can be configured:
- join 2 or more table originating from same source
- source filter.
- number of sorted ports
- select distinct rows
- user defined join
- specify pre-sql and post-sql query
- sql override.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
Why filter transformation is an active one?
What is a sequence generator transformation?
How can you increase the performance in joiner transformation?
can anyone suggest best free Talend data integration training online
What is session task and command task?
Separate from an archive server and a powerhouse?
How to handle decimal places while importing a flatfile into informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Mention a few design and development best practices for informatica?
How do you change a non-reusable transformation to reusable transformation?
How to update or delete the rows in a target, which do not have key fields?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is SDLC way of code development?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?