What is souce qualifier transformation it is active or
passive
- 2 Answers
- 9527 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / smarati
It is active transformation because,
- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition
All the above increases/decreases the number of rows, so SQ
is active.
Thanks
Som
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the difference between router and filter?
What are the features of complex mapping?
What is the use of an aggregator cache file?
Explain how many types of dimensions are available in informatica?
How can repository reports be accessed without sql or other transformations?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the differences between a connected lookup and unconnected lookup?
How to join three sources using joiner? Explain though mapping flow.
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the command used to run a batch?
What is a dimensional model?
How can we handle two sessions in informatica?
How to Create a folder using pmrep command?
Differentiate between a database and data warehouse?
