Interested to Buy Any Domain ? << Click Here >> for more details...
can we use sequential file as a lookup
- 7 Answers
- 23817 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / kiran
hai..,Tell which situation u want.(Define column names and
data.)
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / raja sekhar
Can not use sequential file as lookup because the sequential fine cannot have any key columns.and also it can not support any reference links.the lookup performs based on the key column.
| Is This Answer Correct ? | 6 Yes | 7 No |
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
what is the use of surogate key in datastage
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
What are the steps needed to create a simple basic datastage job?
Where do the datastage jobs get stored?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Define Routines and their types?
How the ipc stage work?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
How can we run same job in 1 day 2 times
What is the difference between validated and compiled in the datastage?
What is the default execution order of the sequential file?
Teradata 
