what is sql override?what is the use of it?
Answers were Sorted based on User's Feedback
Answer / sunil
When u want to override the default sql query we will use
sql override
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / soujanya
It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates
| Is This Answer Correct ? | 12 Yes | 0 No |
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 |
It is a process of defining the user defined SQL queries to filter data, joining the data ,sorting the data and eliminating duplicate records.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
What are the differences between a connected lookup and unconnected lookup?
What is the procedure to load the fact table.Give in detail?
what are cost based and rule based approaches and what is the difference?
Describe expression transformation?
how to through logic of informatica using the push down optimization into oracle.
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
What do you mean by worklet?
Suppose we do not group by on any ports of the aggregator what will be the output?
when we dont use aggregator in mapping ?
guys which is the best institute in banglore to learn informatica??
What is the cumulative sum and moving sum?