DSXchange

Hello All

Slowly Changing Dimension stage in 8.5 is capable to handle Rapidly Changing Dimension (For Type 2) ?

Example:

In the same run for the key 'A' changed values as "DESC*"


A,DECS,Timestamp
A,DESC1,Timestamp
A,DESC2,Timestamp

Thanks in Advance
DS User

Read it for max length and make a logic in Transformer to split the data as needed.

DS User

Hello All A job was running good and all of the sudden it starts to fail. This is the error i got. main_program: Fatal Error: Destination "inputData.SRC_CODE" is already bound. RCP is enabled in this Dev environment. I exported the dsx for this job and marked the values from 1 to 0 for RCP...

Thanks Ray.

Hello All

I am trying to design a shared container using RCP. As per the job logic the input data need be sorted based on the key columns. Is it possibile to choose the key colums, sort it at the run time?

Thanks
DS User

"CAST " it.

Hello All

I deleted the Dataset files and recreated. Now it went smoothly.

DS User

Hello All I developed a Datastage (Finally a transformer will split the data and write into two Dataset files) job which is writing the output into Dataset file(s). In the first run it went smoothly without any warning / issues. But in the second run, it is giving warning and then aborted. main_prog...

You can hardcode the value as a param and then pass that to Modify stage

Hi All Using Datastage 8.1 on Windows with SQL Server 2008 R2 as a target. Trying to load 80 million reocords from Dataset to SQL Server. Job is keep on aborting with the below error. APT_CombinedOperatorController,6: Unable to map file /Z=/IBM/Datasets/LoadData.ds.xxx.server.0000.0006.0000.57b0.cfb...

Sorry friend. As i remember, in one of the project a job used to get killed because of the volume. Then i was advaised to use this variable and then it went smoothly and i guess this will help. Anyhow Real gurus will give good solution. Meanwhile ask with your unix admin to track while you run this ...

I am not sure how much this will help.

Add APT_NO_JOBMON for that job and make it as true and give a try.

DS User

Check the privilege for the user connecting Oracle through Datastage.

DS User

try without unicode

Write it in Dataset and from there to table.