Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 2 Answers
- 7346 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
we can join two table by using source qualifier t/r
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
| Is This Answer Correct ? | 4 Yes | 1 No |
what are the production issues in datastage?
What is the difference between project backlog and product backlog?
Explain different types of partitioning?
what is the difference between normal & bulk loading? and which one is recommended ? why?
what is the difference between OLTP database and data warehousing database?
When do we analyze the tables?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
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 the use of structures?how many nodes can u create in a structure?
what is meant by drill through?(Mascot)
Explain what is etl process? How many steps etl contains explain with example?
Teradata 
