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?



When will you use SQL override in a lookup transformation?..

Answer / 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

More Informatica Interview Questions

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  


How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  


without matching columns in two tables. how can you join

5 Answers   BirlaSoft,


In target table how to display the system time

1 Answers  


if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  


can we generate reports in informatica ? How?

3 Answers  


If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,


daily how much amount of data send to production?

4 Answers   HSBC,


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


How we can use union transformation?

0 Answers  


Categories