what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 144864 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rahul
all the three stages are differ with each other mainly
depends on three categories
1)input column requirements
a) sorting
b)de duplication
2)treatment of unmatched data
3)memory usage
1.. sorting in joins and merge in primary table and
secondary table is mandatory where in look up its optional.
de duplication in joins its allowed no warnings and no
job aborts.
in case of look up in primary table its accepted but in
secondary it raises warnings.
in merge primary table raises warnings in secondary
table its accepted.
about treatment of unmatched data and about memory discussed
above by some one..
thank you
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
options available in sequence job to run,validate?
I have a few records just I want to store data in to targets cycling way how?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
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?
CHANGE CAPTURE
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is meta stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Explain entity, attribute and relationship in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Give an idea of system variables.
What is the different type of jobs in datastage?
How to reverse the string using SQL?
