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
- 3655 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
how do u set partition points in the mapping?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain etl mapping sheets?
What are the various tools used in etl?
What is etl tool in hadoop?
what is the use of server manager?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is etl process?
What is partitioning? Explain about round-robin, hash partitioning.
What is a mapping, session, worklet, workflow, mapplet?
how do u identify the changed records in operational data?
what are the facilities provided by data warehouse to analytical users?
What is tracing level? How many types of transformations supported by sorted input?
Explain the key challenges that you face while performing etl testing.
