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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Terminate Activity
State the difference between an operational datastage and a data warehouse?
Differentiate between datastage and datastage tx?
What is the difference between server job and parallel jobs?
Describe stream connector?
What is the purpose of interprocessor stage in server jobs?
What are the types of containers and how to create them?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How many types of sorting methods are available in datastage?
options available in sequence job to run,validate?
Explain ibm infosphere information server and highlight its main features?
What is a datastage job?
What is the difference between informatica and datastage?