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
How to generate or load values in to the target table based on a column value using informatica etl tool.
Briefly describe lookup transformation?
What is the difference between Active and Passive transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How we can use union transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the measure objects?
what is diff b/t sorter t/r and agg have the option sorter property...
What is a surrogate key?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the command used to run a batch?
Explain the etl program with few examples.
Partition, what happens if the specified key range is shorter and longer
What is native users?
What is workflow? What are the components of workflow manager?