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

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

How a server job can be converted to a parallel job?

0 Answers  

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

What are stage variables and constants?

0 Answers  

What is active and passive stage?

0 Answers  

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

Terminate Activity

0 Answers   CTS,

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,