can we use sequential file as a lookup

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Question Posted / narsi

7 Answers
23921 Views
Cognizant, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we use sequential file as a lookup..

Answer / vijay

Hi kiran,

pls Explan ur ans.

Is This Answer Correct ?

0 Yes

0 No

can we use sequential file as a lookup..

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

can we use sequential file as a lookup..

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

can we use sequential file as a lookup..

Answer / kiran

hai..,Tell which situation u want.(Define column names and
data.)

Is This Answer Correct ?

0 Yes

1 No

can we use sequential file as a lookup..

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

can we use sequential file as a lookup..

Answer / simha

could u explain how to use that?

Is This Answer Correct ?

0 Yes

2 No

can we use sequential file as a lookup..

Answer / kiran

yesU can use seq file as a lookup

Is This Answer Correct ?

12 Yes

15 No

Post New Answer

More Data Stage Interview Questions

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers TCS,

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers IBM,

What are the different database update actions available?

1 Answers HP,

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers Alpharithm Technologies,

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers

What are the types of containers?

0 Answers

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers

which r the connectors used in san?

0 Answers

What is active and passive stage?

0 Answers

How To find the location of APT_confid file

2 Answers CTS,

Difference between server jobs & parallel jobs?

0 Answers

For more Data Stage Interview Questions Click Here