I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Answers were Sorted based on User's Feedback



I have two tables in two different database, so to join these tables which transformation will be be..

Answer / bhavemanali10

Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database

Is This Answer Correct ?    1 Yes 0 No

I have two tables in two different database, so to join these tables which transformation will be be..

Answer / kvikas2056

Thank you manali,
But can you please explain why joiner is better than lookup??

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

What are various etl tools in the market?

0 Answers  


Compare etl & elt?

0 Answers  


what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  






What is Data Vault???

0 Answers  


what is session partitioning?

1 Answers  


What is etl process? How many steps etl contains?

0 Answers  


can cubes contain measures ?

0 Answers  


Two different admin users created for repository are________and_________.

1 Answers  


What is tracing level and what are the types?

0 Answers  


Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,


Categories