DSXchange

Arraysize = 1 L and commit size = 1 L option or found only in Oracle OCI stage (i.e server jobs)

Can u please guide me how do I handle the same with server Jobs

Hi, I have to insert close to 10lakh into oracle database. The datastage caches all 10 lakh records and then inserts and performs a commit .... Now what I wanna do is that , the insertion should happen for very 1 lakh records and a COMMIT should be performed at this stage ... Kindly let me know if t...

Hi All,

Is it possible to read job parameters from a file ??
If yes how can it be accomplished??


Thank u!

Yeah I have DataStage installed..

Thank u

Hi all,

I have a basic question. I want to know how datastage exactly works, like its architecture? How each stage is treated? How each row is handled in different stages?? It would be helpful if anyone could suggest some documents regarding the same.

Thanks in advance

Thank You all..

It finally worked.. :D
I did as u suggested

Thank u chulett ..
I had not thought in this direction.


I tried using Link collector but I get a compilation error

"Link Collector stage does not support in-process active-to-active inputs or outputs"

sorry .. :oops: I have four sequential file to read data from 4 files. Each file I apply different transformation and output from the transformer is sent to a single file stage. 4 sequential file stage(Input) --> 4 transformer stage (for each file)--->1 sequential file stage(output) My problem is my...

I am using sequential file stage to read as well as to write the file

Hi.. I have a scenario where in I have to reading 4 files and transform them and then load it into a single file. My problem is the job loads only data from one file. It doesn't throw any error but rather than loading 30 records each from 4 files it loads only data from one file. I have checked appe...

Thank u ...

You helped me clear my doubt. The files vary a lot from each other. So I guess I'll go with ten jobs.
I just wanted to be sure that I was not missing on something.

Ok..

So u mean using parallel jobs also I cant archive transferring 10 files of different structure using a single job.

Thank You

Hi,

Can I achieve the job I mentioned in this post using parallel jobs.

Hi, I have a scenario where in I want to look up on the same table twice. So I have used a LoopUp stage with two oracle stages connected to it lets say ora_table and copy_ora_table both representing the same table ora_table . The first Lookup on the ora_table doesnt have any problem. But I am not ge...

Hi,

When I run my Job, The job aborts with the following error...
"main_program: Fatal Error: Source "coloumn_name" is already kept"

Can anyone tell me what does this error mean.
Thank you