Interested to Buy Any Domain ? << Click Here >> for more details...
can we use sequential file as a lookup
- 7 Answers
- 24121 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
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
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
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.
Can you explain engine tier in information server?
whom do you report?
State the difference between an operational datastage and a data warehouse?
How to convert RGB Value to Hexadecimal values in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What all are the different way to run a job?
What is quality stage?
What are the different type of jobs in datastage?
Define Job control?
What is the purpose of interprocessor stage in server jobs?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
