Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149004 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kpk
all three stages are used to join database tables based on a
key column.
Lookupsate: input 1 reference any number (if oracle or DB2
only 1 reference link) one out put link and one reject link.
faster if the volume of data is less than the memory size.
if the siz is too huge then DS uses scrap files to store the
remaining datas and that hinders the performance.
Joinstage: can have any (but i think only 16 )tables can be
joined. does not use memory, look up is done on table level,
so would be better to use if the data volume is pretty
huge.dosent have any reject link. only one out put link.
Mergestage: can have any number of input link and update
link. need to have a key column. can have any number of
reject link. only one out put link.
| Is This Answer Correct ? | 25 Yes | 17 No |
Post New Answer View All Answers
What steps should be taken to improve Datastage jobs?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
whom do you report?
Demonstrate experience in maintaining quality process standards?
How a server job can be converted to a parallel job?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is datastage?
Name the different types of Lookups in Datastage?
Define data aggregation?
How you Implemented SCD Type 1 & Type 2 in your project?
What is ibm datastage?
What are some prerequisites for datastage?
what is use of SDR function?
Can you explain repository tables in datastage?
