what is sql override?what is the use of it?
- 4 Answers
- 15124 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.
if no please let me know the correct answer
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
What is difference between a gateway node and worker node?
What is the Process to creating lookup transformation in informatica
Mention few power centre client applications with their basic purpose?
What are the popular informatica products?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are some examples of informatica etl programs?
What is decode in static cache?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you load alternate records into different tables through mapping flow?
Describe the impact of several join conditions and join order in a joiner transformation?
Separate from a database, an information bazaar, and an information stockroom?
can we override a native sql query within informatica? Where do we do it?
How to go to the older version for a mapping?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
