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
- 2868 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 |
Can u access a repository created in previous version of Informatica?
Do we need an ETL tool? When do we go for the tools in the market?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
what is the use of server manager?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
where is the cache (lookup, index) created and how can you see it.
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Is apache nifi an etl tool?
when should one create lookup transformation ?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What is factless fact schema?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Teradata 
