Interested to Buy Any Domain ? << Click Here >> for more details...
can we use sequential file as a lookup
- 7 Answers
- 24156 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 |
how can u handle null values in transformer stage.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
what is flow of project?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
whats difference between ls -ltr and ls -lrt?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
Is possible to create skid in dim,fact tables?
what are the errors,warnings in datastage
How rejected rows are managed in datastage?
What are the types of jobs we have in datastage?
Teradata 
