DSXchange

Hi All, I want to apply the SCD2 in the dimension tables. and I read from ETL stats Tech Tip slowly cahnged dimensions document. In that they are using the transformer stage as loo up . Whan i am trying to inplement this it is not working. Can any bod please tell how we can do this . Thnaks, Ramesh.

Thanks chullet,

Can you please provide me the details how to use that . I am new to data stage .please explain in detail how i can load into tables .

Thanks,
Ramesh.

Ok Ray, Thanks alot for replying for my post.

Thanks,
ramesh.

Hi Ray,
Thanks for the response.But i am not the premiun member so i cant able to read the answer which was provided by you.If you dont mine can you please provide me the answer .

Thanks ,
Ramesh.

Hi All, I am new to data stage.I need some information regarding the partition key which need to be appliedon the fallowing stages. 1)Aggregator 2)Stored procedure. 3)filter 4)funnel 5)look up 6)transformer Please provide me normally which partitions are applied on these stages. we are applying same...

Hi All, I am using the routine to take the job report and place the report in the sequential file. But the reqirement for me is to load the job report detials like job start time ,job end time,No of rows inserted , No of rows rejected etc into the Data_Audit_table into the data base. How can i do th...

Hi Arnd W,
I am using the Round Robbin option in the oracle stage .

Thanks,
Ramesh.

Hi All, I am running a small jobwith sequential file as input ,Transformer &Oracle enterprise stage as output. I applied partitions bykeeping entire partition on Transformer stage and round robbin on oracle enterprise stage . But upto transformer the data flow is very fast and showing about 4500...

Thanks all , I tried by using change data capture stage .But it is not giving the exact resullt which is coming through query . I think i am giving wrong keys &values in the properties. What my requirement is "the records which are coming in current months from the file minus the rexcords t...

Hi all,

I want to perform the minus which we will do in oracle through datastage .Is there any stage which will perform this .

Thanks in advance

Ramesh .

Hi All, I am new to data stage i just need to have the Job statistics (Number of rows inserted, rejected ,Job Start date ,Job end date ,job id ) to be captured into the table for each job.For this we are thinking of writing a routine to capture this inforamtion into the Sequential file and from that...

Hi All,

I have a doubt why ODBC Enterprise stage is not used in the parallel jobs.Instead we need to use the Oracle Enterprise Stage. Can any one can tell me the Pros And Cons of using this stages in parallel jobs.

Thanks,
Ramesh.

can you please explain how this can be implemented by using the build stage.

Thanks Ray
Then when we need to use the Decode stage. It can be better for me to understand if you can provide the example.

Thanks,
Ramesh.

I need to decrypt the information which is encrypted .can i do that using decode stage?.If no then is there any stage by which i can do that .


Thanks,
Ramesh.