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
how do u identify the changed records in operational data?
what happens if the info.server doesn't find the session parameter in the parameter file?
What are the different etl testing categories as per their function?
What is the difference between round-robin partitioning and hash partitioning?
Explain about round-robi?
Mention few test cases and explain them?
How to increase performance without changing anything in mapping.( In prod)
Explain do we need an etl tool?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
When do we analyze the tables? How do we do it?
what is pmrep command?
Explain etl?
what is Forward,Reverse and Re_engineering?
SCD2 will work on only dimension tables as well as fact Table?
where is the cache (lookup, index) created and how can you see it.