DSXchange

Thanks every

it was very helpful

I just had a look at some of the flat files and they r very huge approx 440000000 bytes (420 GB). How come? Does this mean that the Unix Administrators can change the size limit on the files???

Thanks everyone,

Chulett, yes it is disk storage, sorry wasnt careful to write properly.

ArndW, how do we declare 64 Bit, I mean where?

One more question,

is it advisable to create hash files & flat files in other job or in the same job?

Regards

Hi all, Got a doubt regarding flat files. Would be pleased if someone could answer it. Say i have got 2 tables in oracle coming from different schemas. One being the lookup. I know that using hash files and flat files speeds up the processing time. At the same time I am concerned about the size of t...

Hi all,

Does anyone have idea to implement right outer join in datastage.

for instance,

A.Value=B.Value(+)

Where B is the look up.

Regards

Hi there, I dont have a parallel version with me, but have a doubt regarding it while discussing with my friend. Can we extract data by using single oracle stage from two different schemas using SQL statements??? Can one stage be used to connect to two schemas? eg : select A.id, A.dat1, A.dat2, B.id...

I need to convert from flat file, so guess i need to try what DSguru2B says. I will let you all know tomorrow after giving it a try

sorry posted a bit wrong

its actually

id, sales_typ1_amnt, sales_type2_amt, sales_type3_amt

and need it like

id, sales_typ1_amnt,
id sales_type2_amt,
id sales_type3_amt

Hi all, need a bit of help with splitting into multiple records. i have 7 columns as shown below (ps there are more than 7 columns in the table) id,sales_typ1,sales_amt1,sales_typ2,sales_amt2, sales_typ3,sales_amt3. I want to split into three records as below id,sales_typ1,sales_amt1, id, sales_typ2...

Hi All, This seems to be another simple question to you all. But a bit tough for me :( . I have here with me a prototype of ETL jobs done. This now needs to go up against the database. Now I need to come to conclusions as to how to maintain the history data. Because everytime job is executed, fresh ...

I got the problem. Sorry to trouble. I wasnt builidng the SQL query for both the Links of OracleStage1. I was doint it only for one i.e the link to the transformer. I didnt build SQL query for the link going to aggregator stage.

Thanks for bearing

Also theres a warning message which states that,

Attempting to Cleanup after ABORT raised in stage OracleStage1

I didnt get the figure, properly. The two veritcal lines are one for each oracle stage

I keep getting this error. Table Name is a required link property for Link XYZ. I have the setup this way : a) both oracle stages are linked to Tranformer as lookup b) I am getting the error for oracle stage 1 OracleStage1 -----> Aggregator -------> OracleStage2 | | | | | | TRANSFORMER I have checke...

Hi no one is answering