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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between source qualifier and joiner transformation?

1062


Differentiate between router and filter transformation?

1012


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361


can u any challenge your project?

2033


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279


How many input parameters can exist in an unconnected lookup?

1545


Write the unconnected lookup syntax and how to return more than one column.

1110


How can you differentiate between powercenter and power map?

1091


How to update or delete the rows in a target, which do not have key fields?

1178


How to start a workflow using pmcmd command?

1252


Design a mapping to load the cumulative sum of salaries of employees into target table?

1505


What is difference between a gateway node and worker node?

1141


r u done any partitions in ur project?

1827


Explain why we use partitioning the session in informatica?

1094


What is the difference between informatics 7x and 8x and what is latest version?

1085