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 |
Explain about Recovering sessions?
How to identify this row for insert and this row for update in dynamic lookup cache
Could any one to tell Fact table Partitioning?
waht type of interface is used for testing the data in informatica
Mention few advantages of router transformation over filter transformation.
what is $$$$?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is option by which we can run all the sessions in a batch simultaneously?
How can we improve session performance in aggregator transformation?
what is the purpose of surrogate key and diff between primary key&surrogate key
What are differences between Informatica 7.1 and 6.1
What is lookup change?