Answer / vijay

Hi kiran,

pls Explan ur ans.

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.

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

Answer / kiran

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

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.

Answer / simha

could u explain how to use that?

Answer / kiran

yesU can use seq file as a lookup

What are the types of hashed files in data stage

0 Answers  

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

what is sparse lookup?

7 Answers   IBM,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

what is executable in DataStage?

2 Answers  

what is main difference between change capture and change apply stages

4 Answers   IBM,

Define meta stage?

0 Answers  

difference between function and procedure...

1 Answers   IBM,

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

how can we do null handling in sequential files

2 Answers   Reliance,

Thanks to all people who are posting their comments...

1 Answers   CTS,

which cache supports connected & un connected Lookup

1 Answers   Wipro,