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 to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.

Answers were Sorted based on User's Feedback



how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / maruthi

using sql over ride in s.qualfier

Is This Answer Correct ?    7 Yes 0 No

how to join two tables without using joiner transformation .advantages of joiner over lookup and vi..

Answer / kasi reddy

using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More ETL Interview Questions

how do u extract data from different data sources explain with an example?

0 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

0 Answers  


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

0 Answers  


we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  


how do u set partition points in the mapping?

0 Answers   Quintiles,


when should one create lookup transformation ?

2 Answers  


What are the new features of informatica 9 version?

2 Answers  


what are the different forms of normalization?

2 Answers  


Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,


What is a mapping?

0 Answers  


Categories