explain abt joiner t/r?
Joiner transformation is used to join source data from two
related heterogeneous sources. However this can also be used
to join data from the same source. Joiner t/r join sources
with at least one matching column. It uses a condition that
matches one or more pair of columns between the 2 sources.
To configure a Joiner t/r various settings that we do
are as below:
1)Master and detail source
2)Type of join
3)Condition of the join
Is This Answer Correct ? | 5 Yes | 0 No |
Partition, what happens if the specified key range is shorter and longer
What are the designer tools for creating tranformations?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
What is a snowflake schema?
Is it possible to have "5 source & 5 Target" in single mapping?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Which is the t/r that builts only single cache memory?
what are the deliverables?in your project?
After we make a folder shared can it be reversed?Why?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?