why we use source qualifier transformation?
Answer Posted / ashok j
When we drag and drop the source table to mapping designer,
it automatically comes up with the SQ. SQ tranformation can
send the data to next level trasformation or target.
With the property Sql override, you can perform the
operations from the database level like aggregation, filter
condition, Expressions, join etc by writing appropriate
quries.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
On which transformations you created partitions in your project?
Do you find any difficulty while working with flat files as source and target?
What do think which one is the better joiner or look up?
What is joiner change?
What is a repository manager?
What differs when we choose the sorted input for aggregator transformation?
What are the data movement modes in informatica?
What is the way to execute pl/sql script using informatica mapping?
Under what condition selecting sorted input in aggregator may fail the session?
What is fact table? Explain the different kinds of facts.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the issues you have faced in your project? How did you overcome those issues?
Which transformation should we use to normalise the COBOL and relational sources?