Answer Posted / chenna
sparse lookup has more memory so that if reference table
contains huge amount of data perfer to use sparse lookup
Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
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
What is the precedence of stage variables,derivations, and constraints?
Lookup constraints
What are the types of containers in datastage?
What is use Array size in datastage
Difference between data warehousing and olap?
In Datastage, how you can fix the truncated data error?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How many types of hash files are there?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How a source file is populated?
What all the types of jobs you developed?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Name the third party tools that can be used in datastage?
What are the primary usages of datastage tool?