Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149288 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
How to reverse the string using SQL?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the steps needed to create a simple basic datastage job?
How do you run datastage job from the command line?
Differentiate between Join, Merge and Lookup stage?
What is the roundrobin collector?
What is the difference between passive stage and active stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
Differentiate between data file and descriptor file?
Can you explain kafka connector?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you import and export the datastage jobs?
How do you start developing a datastage project?
On which interface you will be working as a developer?
What are the types of jobs we have in datastage?
