DSXchange

Hi, I have one stranege problem designing a job. Specification: Source is a fixed width file(Text). In that one field is P_status is of varchar(1) type and nullable is Y. In target the above mentioned field is char(1) type and not nullable. Requirement is to not to process null in that field to tar...

You will first need to create a surrogate key source through a separate job throwing only the SK key gen stage in that job. It will allow you to specify the namd and location of the SK source key. Now, that you have created it you will need to access/point to the source everytime. You will now need...

rajesh.ravi wrote:while using View Data i got a error when it was fisrt time used. I am learning parrllel job.

pls help me for this issue.

Can you describe what properties you are setting in the OCI Stage.

But I found no place in the loopup stage to set a default value for the column. The extended property is shown as "None available" you want a piece of cake ready to eat! Just pass the stream link attribute along with the value getting from reference link after making it nullable. and in d...

But I found no place in the loopup stage to set a default value for the column. The extended property is shown as "None available" you want a piece of cake ready to eat! Just pass the stream link attribute along with the value getting from reference link after making it nullable. and in d...

Ray, Thanks for the reply. The first way which comes to our mind is passing POST_DATE along all the links. But I am intested in knowing the alternates. Way suggested by Ray is most appropriate one thats why he suggested it. can you think about another better option? you can't. lets see another opti...

Note: the generator is creating a number. You can not apply the transformation within the generator operator. You must add the leading zeroes in a downstream Transformer stage. ... You can change the datatype in surrogate key generator from unsigned bigint to Number of length greater than length of...

Sorry to not post anything helpful here, but Ernie - do these components now ship with the 8.x product or are they still a separate purchase? M - do you actually have these components (and thus the accompanying documentation) or are you just asking about them to see if they would help? Hi Craig, Th...

Hi Maveric, If I understand correctly, i think the one you suggested will not work for me. because, I need to get all the rows from PROFOTHER_FACT table and I need to update inp_ind field with "Y" if PROFOTHER_FACT.PROFOTHER_SERVICE_ID = STAY_LINK_FACT.RELATED_SERVICE_ID. and the rest. Th...

Hi... I don't know how to get rid of it, but it's also unlikely to be important. Mulitple "waves" are usually only an issue with WISD or RTI jobs, or other "real time" scenarios, such as sourcing from MQSeries. Each "wave" marks a single logical request that is flowing...

Now I have changed my job a lot according to other posts for last two errors Now I am getting only one warning i.e. main_program: Operator "parallel APT_KeyGenerator in SKG_Ins" is not wave aware; the operator will be reset and rerun on each wave if multiple waves present. This may lead to...

Operator "parallel APT_KeyGenerator in SKG_Ins" is not wave aware; the operator will be reset and rerun on each wave if multiple waves present. This may lead to incorrect results and memory issues. Update the operator to make it wave aware and calls setWaveAware() in describeOperator() to...

Hi, What is the main difference between data set and file set stage? What are the things should be considered before deciding abt the data set and file set stage? Thanks in advance, Birendra Birendra, Dataset is an internal format of DataStage the main points to be considered about dataset before u...

Hi Just like Ray Pointed out if you want DSGetJobInfo()-you can use an AfterJob subrotuine which still uses an BASIC for what ever functionality u want to use it for... If you need a tutorial on how to write parallel Routines...check this blog by vincent... http://blogs.ittoolbox.com/bi/websphere/a...

WHERE are you proposing to use this function? If you need the row count inside a Transformer stage it's already exposed through system variables. If you don't need it until the job has processed all rows, then you can use DSGetJobInfo() - or the macros that you discovered - in an after-job subrouti...