What is sql query override? When did u use sql query override?

Question Posted / jey.dgl

1 Answers
6948 Views
TCS, I also Faced
E-Mail Answers

What is sql query override? When did u use sql query override?..

Answer / santhosh

sql override is used to write sql select statements
sql override contains in source qualifier transformation

we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database

Is This Answer Correct ?

6 Yes

0 No

Post New Answer

More Informatica Interview Questions

why we are using level option in normalizer transformation

1 Answers TCS, Wells Fargo,

What is source qualifier transformation in informatica?

0 Answers

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers HP,

What are the types of data that passes between informatica server and stored procedure?

1 Answers Informatica,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers CTS, Wipro,

WHat all joins are there in Source Qualifier?

1 Answers

whats the logic to load the lower level of granularity of data to fact table.

0 Answers IBM,

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers TCS,

What is xml source qualifier transformation in informatica?

0 Answers

what is session parameters?

1 Answers Cap Gemini,

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers L&T,

For more Informatica Interview Questions Click Here