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
- 3704 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
What is etl tool in hadoop?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
When do we analyze the tables? How do we do it?
how to connect to a flatfile through ftp in informatica
what are the data modeling tools you have used?(polaris)
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
what is pmrep command?
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.
What is meant by incremental load?
When do we go for the tools in the market?
Define Dynamic push down optmization?
what is session partitioning?
what is an ETL or ETT? And what are the different types?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain the key challenges that you face while performing etl testing.
