Answer Posted / varma
Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Describe the main features of datastage?
How do you run datastage job from the command line?
Can you filter data in hashed file?
Can you explain engine tier in information server?
Explain how a source file is populated?
How to Remove Duplicate using SQL?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the different types of lookups in datastage?
How will you move hashed file from one location to another location?
how to implement scd2 in datastage 7.5 with lookup stage
Explain the importance of surrogate key in data warehousing?
What are constraints and derivations?
What are the steps required to kill the job in Datastage?
What are the main features of datastage?