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

How do you create single lookup transformation using
multiple tables?

Answer Posted / bsgsr

join the tables in the database itself then do the look up
else override the lookup sql and look up.
i believe this would work.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the tuning lookup transformation - informatica

996


What is the need of an ETL tool?

1101


How to start a workflow using pmcmd command?

1253


Explain target update override in informatica

1126


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1206


What is the maplet?

1124


Can we change Dynamic to Static or Persistent cache? If so what happens?

2211


Different qualification between a related rotate toward the sky and isolates look upward?

988


What is joiner change?

1148


What is a router transformation?

1130


How can a transformation be made reusable?

1171


What is aggregator transformation in informatica?

952


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

2361


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036


Global and Local shortcuts. Advantages.

2034