what is sql override?what is the use of it?

Answers were Sorted based on User's Feedback



what is sql override?what is the use of it?..

Answer / sunil

When u want to override the default sql query we will use
sql override

Is This Answer Correct ?    22 Yes 2 No

what is sql override?what is the use of it?..

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

what is sql override?what is the use of it?..

Answer / 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

what is sql override?what is the use of it?..

Answer / chandumba2005

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

Post New Answer

More Informatica Interview Questions

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,


What are pre and post-session shell commands?

0 Answers  


how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,


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.

1 Answers   DELL,






Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


What are the tasks that source qualifier perform?

0 Answers   Informatica,


how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,


Kimball and Inmon methodologies?

2 Answers  


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


What is synonym?

2 Answers   Patni,


Categories