I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
- 2 Answers
- 2653 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Thank you manali,
But can you please explain why joiner is better than lookup??
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are the different Lookup methods used in Informatica?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
how do u automate Extraction process?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the difference between cardinality and Nullability?
what is Forward,Reverse and Re_engineering?
What are dimensions?
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
What is partitioning? Explain different types of partitioning?
Which type or t/s is used to convert rows into column & column into rows
what make u disappointmnets in u r career
Teradata 
