how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between cubes and package in cognos
What is a staging area? What is the purpose of a staging area?
What is data cleaning?
what is pmrep command?
what is the difference between cardinality and Nullability?
Explain about the data integration suite features?
Explain about enterprise scalability and roi of data integration suite?
Give the benefits of data integration suite?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
Do we need an etl tool?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
can cubes contain measures ?
what is the difference steps for data modeling?
How to increase performance without changing anything in mapping.( In prod)
what is pmrep command?