how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / k bhavani durga
this can be used to join two sources coming from two
different locations or from the same locayion.for this
there mist be atleast one matching port and it is must to
specify one source as master and the other as detail.
it supports the following types of joins
1.normal
2.master outer
3.detail outer
4.full outer
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the key challenges that you face while performing etl testing.
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what are the production issues in datastage?
Compare etl & elt?
how would u estimate the size of Aggregator transform data and index cache?
what is dynamic insert?
what is the difference between cubes and package in cognos
what is different between sequential batch and concurrent batch and which is recommended and why?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is etl process?
how do u really know that paging to disk is happening while u are using a lookup transform?
dimension object created in oracle can be imported in designer?how?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
Mention few test cases and explain them?
What is etl process. How many steps etl contains explain with example?