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 different common services in datastage?

1 Answers  

What is PX?

2 Answers   IBM,

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

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,

What is the flow of loading data into fact & dimensional tables?

1 Answers  

What is the difference between in process and inter process?

1 Answers  

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   Wipro,

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

Difference between in process and inter process?

1 Answers  

client know skid info?

1 Answers   NTT Data,

Pls tell me what is troubleshooting in datastage view?

1 Answers  

How to Convert the columns into rows?

2 Answers