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
- 2669 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 tracing level?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is tracing level? How many types of transformations supported by sorted input?
how would u estimate the size of Aggregator transform data and index cache?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Which type or t/s is used to convert rows into column & column into rows
what is the difference between cardinality and Nullability?
Need Informatica Power Center 9.1 free download(for all windows version)
How we can see table structure?
what is the difference between cubes and package in cognos
Explain about the data integration suite features?
Explain different types of partitioning?
Teradata 
