can we use sequential file as a lookup
- 7 Answers
- 21187 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 |
Explain connectivity between datastage with datasources?
how to cleansing data
What are the functionalities of link partitioner?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
How you Implemented SCD Type 1 & Type 2 in your project?
How do you start developing a datastage project?
Differentiate between hash file and sequential file?
What modeling tool do you use?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
what is the difference between the join and look up explin me one exmple
How can remove duplicates in a file using UNIX?
Teradata 
