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 |
enterprise datawarehouse your project phase by phase explain?
What are pre and post-session shell commands?
how can one come to know wether the records loak into the target if we use update strategy
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
 Code page compatibly –Where all changes are made to handle the scenario.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the tasks that source qualifier perform?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
Kimball and Inmon methodologies?
Performance wise which is better joiner or look up ? Give me with example?
without dynamic lookup transformation how to insert new rows and update existing rows?
What is synonym?