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
Different qualification between a related rotate toward the sky and isolates look upward?
What is fact table? Explain the different kinds of facts.
COM components can be used in Informatica
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.
What are the mapping parameters and mapping variables?
What is transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Performance tuning( what you did in performance tuning)
What are the conditions needed to improve the performance of informatica aggregator transformation?
Define mapping and session?
what is the -ve test case in your project.
How can we delete duplicate rows from flat files?
What is domain and gateway node?
What is informatica metadata and where is it stored?
What is meant by LDAP users?