DSXchange

Welcome Aboard :) You have posted in the wrong forum. This forum is for parallel job specific question. You hardcode the value for the key while building the hashed file to say 'X'. When you read the hashed file, hardcode the value 'X' for the key and for each incoming record, the hashed file will ...

Hi, As per design standards, we keep IPC stage between 2 passive stages, This improves performance.Why can't we go for transformer stage, what is the advantage in choosing IPC stage over transformer stage between 2 passive stages. cheers; saama Hi Saama, Consider a simple job where source is a flat...

Iconv() doesn't need the format but, if given, it must be right. You have omitted "A" for the month. Oconv(Iconv(ToT1.START_DATE,"D-DMY[2,A3,2]"),"D-YMD[ ...[/quote] My transformation logic is: Oconv(Iconv(ToT1.START_DATE,"D-DMY[2,A3,2]"),"D-DMY[2,2,4]")...

Thanks everyone for your tips. Writing to a file to see whether the problem was in the stage was very usefull as well as the tip to drop the indexes before and add them after the inserts and updates. I also added a hash file to make sure the table I was looking up on had no conflict with the table ...

When starting a job it starts to run at a 86 rows per second. When inserting en updating more and more data to a oracle table the performance slowly decreases from 86 rows to eventually a 3/1 rows per second. The job doesn't give warnings so the problem isn't the size of the logfile. The table does...

[quote="Maveric"]If u want to run the job N number of times simultaneously then u need N copies of the job or one multi instance job with N number of instance IDs and N different inputs. If N is unknown then you wont be able to make enough copies

Thanks maveric
George

Hi All, From one of the postings about multiple instance says "Let us assume you have a simple job that you declare as multi-instance. It accepts a source file name as a parameter and all it does is read the sequential file, perform some transformations onto the data and load it into a database...

Hi all, Search has threw light on these areas Full Load is the entire data dump load taking place the very first time. Gradually to synchronize the target data with source data, there are further 2 techniques:- 1.Refresh load - Where the existing data is truncated and reloaded completely. 2. Increme...

Thanks Priyadarshi Kunal,

Can somebody adorn this topic a bit more

Thanks
George Sebastian

Hi Every one, I would kindly like to know, What is incremental loding? Can all the loading which will increment or update the target can be considered as incremental loading. So in that case In Datawarehousing we always go for incremental loading. One more question. What is incremental load? Is that...

Thanks Ray,

I have already searched but it seems the one who is IBM registared only can access the doc.

thanks
George

Thanks Ray,

We have datastage7x,sure i will ask them.But is there any way that i can download it from somewere for free.

Thanks
George

Hi all,

I am very new to Profile stage.I would like to learn it.
Can somebody tell me how to get some stuff(Pdf) about Profile stage?
I dont have profilestage software.

Thanks
George sebastian.

Hi,

I think we have to wait for some of the Gurus .
By the time,Try creating the hashed file in some other location.

Thanks
George

Hi, I want to know the better way of loading a Oracle table(10g). While loading millions of records into Oracle table, which option should be chosen for better performance (without any deadlock issue)? - Using Upsert - Splitting the data stream into 'Insert' & 'Update' stream and using two Orac...