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