what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144867 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
Demonstrate experience in maintaining quality process standards?
What are the areas of application?
Notification Activity
Explain the situation where you have applied SCD in your project?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Explain Quality stage?
How to reverse the string using unix?
What are the processing stages?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
what is 'reconsideration error' and how can i respond to this error and how to debug this
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are routines in datastage? Enlist various types of routines.
AGGREGATOR default datatype
