Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3698 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 |
what is data modeling?
Identifying the bottlenecks in various components of Informatica and resolving them.
Which transformation we use to convert 'NA' to 'Not Available'
Hi, Lookup() is what kind of join ?
Explain etl mapping sheets?
What are the modules in Power Mart?
What is meant by incremental load?
how would u estimate the size of Lookup transform data and index cache?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what is the difference steps for data modeling?
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.
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
Teradata 
