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

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

What is meta stage?

0 Answers  

what is the main difference between sorragate key n primary key in one word

2 Answers  

Define ds designer?

0 Answers  

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

What is job control?

0 Answers  

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

On which Dimension Table you implemented SCD Type in your Project

0 Answers