Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16005 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
Can anyone tell me the new features in Informatica 9 Version?
What is the use of source qualifier?
What are the different versions of informatica?
Does an informatica transformation support only aggregate expressions?
What is an expression transformation?
Explain about cumulative Sum or moving sum?
What is the sequence generator transformation in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Define joiner transformation?
Explain the types of transformations?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
is it possible to index the data in cache of lkp transformation ?
can we override a native sql query within informatica? How do we do it?
can u give example for factless fact table
