Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



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

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,


What is the cumulative sum and moving sum?

0 Answers  


How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,


when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Differentiate between reusable transformation and mapplet.

0 Answers  


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


What is exclusive and normal mode for repository services?

0 Answers  


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


Categories