What are the diffrences between joiner transformation and
source qualifier transformation?
Answer Posted / swetha
yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Which is the t/r that builts only single cache memory?
In development project what is the process to follow for an etl developer from day1
How will the document be delivered to me?
How do you load unique records into one target table and duplicate records into a different target table?
How union transformation is used?
What is enterprise data warehousing?
What is data movement mode in Informatica and difference between them?
What is DR strategy for Informatica project?
What are the transformations that are not supported in mapplet?
What is workflow manager?
Explain the pipeline partition with real time example?
What is the difference between Active and Passive transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is Active lock explain