why we use source qualifier transformation?
Answer Posted / ankit
Source qualifier is the first transformation which reads
data from relation of FF source.
With SQ we can limit the source data or sort or aggregate
or remove the dupliate data via SQL Query.
| Is This Answer Correct ? | 27 Yes | 7 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What is the status code in stored procedure transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What are ETL Tools?
what is diff b/t sorter t/r and agg have the option sorter property...
What is meant by active and passive transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How many number of sessions can one group in batches?
How to generate sequence numbers without using the sequence generator transformation?
Explain informatica architecture - version 8 / 9
where to store informatica rejected data? How to extract the informatica rejected data?
Can informatica load heterogeneous targets from heterogeneous sources?
What are pre and post-session shell commands?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?