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
- 3771 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / bhavemanali10
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 |
Post New Answer View All Answers
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
How many types of transformations supported by sorted input?
what is the difference between cardinality and Nullability?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is a staging area? What is the purpose of a staging area?
what are the types in error loging?
Explain about hash partitioning?
what are the concerns of OLTP and DSS systems?
how would u estimate the size of Aggregator transform data and index cache?
what are the reports developed in sap bw project and what is the requirement for developing it?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
Explain the use lookup tables and Aggregate tables?
What is data cleaning?
What is partitioning? Explain about round-robin, hash partitioning.
