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

Question Posted / jey.dgl

1 Answers
7055 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

difference between informatica 8.6 and 9

3 Answers Atos Origin, BA Continnum Solutions, Core Logic,

How to eliminate duplicates from flat file..what is the procedure

4 Answers

Do you have knowledge in ralph kimball methodology

1 Answers

What is synonym?

2 Answers Patni,

Describe expression transformation?

0 Answers

What is the Rank index port in Rank transformation?

0 Answers Informatica,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers IBM,

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers TCS,

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers Zensar,

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers

What are the reusable transforamtions?

1 Answers

For more Informatica Interview Questions Click Here