can we use sequential file as a lookup
Answer Posted / satya
U can't use Sequential file as Lookup file because
Sequential file don't have any key columns so we might get
duplicate records from lookup.
Don't use Sequential file as Lookup.
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
What is the difference between hashfile and sequential file?
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
Which warehouse using in your datawarehouse
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the job parameters?
What are routines in datastage? Enlist various types of routines.
Define repository tables in datastage?
Difference between server jobs & parallel jobs?
how to abort the job its matain duplicates?
Can you implement SCD2 using join, transformer and funnel stage?
How do you register plug-ins?
How to manage date conversion in Datastage?
How rejected rows are managed in datastage?
What are the steps needed to create a simple basic datastage job?
Whats difference betweeen operational data stage (ods) and data warehouse?