can we use sequential file as a lookup
- 7 Answers
- 21885 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
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 can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the various kinds of the hash file?
How and where you used hash file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How will you move hashed file from one location to another location?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is ds administrator used for?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define Merge?
what is repositery?
How do you generate sequence number in datastage?
What are the job parameters?
If you want to use the same piece of code in different jobs, how will you achieve it?
