how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
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 is tracing level?
what is meant by drill through?(Mascot)
What is etl tool in hadoop?
what is session partitioning?
how do u automate Extraction process?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
How many steps etl contains explain with example?
What is virtual Data Warehousing?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is data modeling and data mining?
Can we create Hierarchies in generic datasources?
Identifying the bottlenecks in various components of Informatica and resolving them.