how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / k.rameshyadav
Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the various tools used in etl?
What is partitioning? Explain different types of partitioning?
what are Lookup caches options? Including persistent caches.
Explain the use lookup tables and Aggregate tables?
what is the main role of FI on business
what is pmrep command?
how do u extract data from different data sources explain with an example?
What are cubes and olap cubes?
what is the difference steps for data modeling?
how do u set partition points in the mapping?
what is Forward,Reverse and Re_engineering?
What is initial load and what is full load?
Two default user groups created in the repository are____and_____.
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
where we cannot use sorter Transformation. if we use then we will not get correct data?