can we use sequential file as a lookup
Answer Posted / chakravarthy kanishka
Look doesnt requires common key coloumn, then why we need key,
if we go for sequential file as a look up, and squential file have huge data,then it hits the performance,again you need to apply the performance techniques to the sequential file while reading the data,so better to avoid sequential file as a reference to look up.
its my guess...
please let me know if wrong.
thanks
kanishka
Is This Answer Correct ? | 4 Yes | 4 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
What are the stages in datastage?
How the ipc stage work?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What steps should be taken to improve Datastage jobs?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is a merge?
Notification Activity
What are transforms and what is the differenece between routines and transforms?
Explain ibm infosphere information server and highlight its main features?
Define meta stage?
What is a merge in datastage?
Which algorithm you used for your hashfile?
What are the processing stages?
How you Implemented SCD Type 1 & Type 2 in your project?