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

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

how to convert rows into columns

2 Answers   IBM,

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

Does datastage support slowly changing dimensions ?

0 Answers  

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

how to write server Routine coding?

0 Answers   Eric,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,