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

we can join two table by using source qualifier t/r

Is This Answer Correct ?    7 Yes 1 No

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

Answer / swathi

using source qualifier and also lookup transformation,

joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More ETL Interview Questions

Can u access a repository created in previous version of Informatica?

1 Answers   DELL,


What are snapshots?

0 Answers  


dimension object created in oracle can be imported in designer?how?

0 Answers  


Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  


How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,


Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


What are your responsibilities as an etl tester?

0 Answers  


architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

1 Answers   IBM, Infosys,


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


What are the new features of informatica 9 version?

2 Answers  


what is the advantage of persistent cache? when it should be used?

2 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Categories