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...

When will you use SQL override in a lookup transformation?

Answer Posted / vanita

For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain about unit testing? in real time?

2205


What are the limitations of joiner transformation?

1114


How you prepared reports for OLAP?

1597


Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012


what is informatica metadata?

1037


What are the restrictions of union transformation?

1041


How many number of sessions can one group in batches?

1158


Briefly explain the aggregator transformation?

1010


How to partition the Session?

1113


Can anyone tell me the new features in Informatica 9 Version?

2129


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10170


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2049


Which version configuration tool used in ur project?

3260


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8203


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294