what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144821 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan
We go for a join stage than a lookup when the referntial
data in look up is more ie.,>=500MB.we have outer joins in
join stage but not in merge stage.we have only inner join
in merge stage.
| Is This Answer Correct ? | 12 Yes | 26 No |
Post New Answer View All Answers
in oracle target stage when we use load option and when we use upsert option?
How do you schedule or monitoring the job?
What are the processing stages?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the benefits of datastage?
Explain datastage architecture?
What are the different kinds of views available in a datastage director?
What is a ds designer?
Why do we use link partitioner and link collector in datastage?
Terminate Activity
What is process model?
how to add a new records into source?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are datastage sequences?
Define Job control?
