Interested to Buy Any Domain ? << Click Here >> for more details...
What is souce qualifier transformation it is active or
passive
- 2 Answers
- 10556 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 an Integration service in Informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What does “tail –f” command do and what is its use as an Informatica admin.
What is a grid in Informatica?
What is pmcmd command?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What do you mean by filter transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we create multiple integration service on single repository?
Informatica settings are available in which file?
Write the unconnected lookup syntax and how to return more than one column.
Explain constraint based loading in informatica
What are the tasks that can be performed using sq?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
