DSXchange

Hi, I have extracting xml data through using below stages rowgen ---> trans---> xml input----->seq I have tried with one file it's working fine, but trying with 2nd file not producing data and not getting any error or warning in director logs, it showing success with exporting 0 records. but both fi...

I didn't understand what u r saying..

Hi,

Can u give an idea of this warning message.

APT_CombinedOperatorController,0: Resource bundle corresponding to message key DSTAGE-TODC-00069 not found! Check that DSHOME or APT_RESPATH is set.

Is there any possibility, even not getting data, keep the 4th output column in output definition and remove the 4th output column in output file.

Hi, I am getting file and it contain 3 columns, but in my sequencial file output page having 4 columns. now the 4th column doesn't have the data, so i don't required the column in the file output, i required only 3 fileds. is there any option in datastage if the column not getting data, suppose to c...

Hi, Please any one can help, in which situation this error can occur. ERROR: ------------ Copy_of_XML_Input_0,0: Error: The prefix 'defns' is not declared. expression = '/defns:Document/defns:CstmrPmtStsRpt' Remaining tokens are: ('/') XML Column Description : ----------------------------- /defns:Do...

Hi, while extracting data from XML, i got below error message and the XML stage have 950 columns., please let me know what to do in this case. ERROR: ---------- Copy_of_XML_Input_0,0: Fatal Error: Virtual data set.; output of "Copy_of_XML_Input_0": the record is too big to fit in a block; ...

it is a flat file.. and loading in to one more flat file. and sorry for the subject which i have mentioned.

Hi, I have to calculate gross amount based on fical year and month and my year starts from september. Ex:Amount, Fiscal year , period, M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12 2013 5 200+300+100+599+829+700+339+09+49+83+590+489 M1 -Sep, M2-Oct, M3-Nov --, and the respective values. Now present month i...

Hi,

I am getting below warning, please some one help to me.

" lkp_Inv_number: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the
preserve-partitioning flag on the data set on input port 0."

Hi,

Please any one give me a solution, if the job fails in 2022 record, after rectifying the issue how to run the job from 2013 records onwards.

Generally i enable the checkpoints, truncate the entire data and re-run the job, but the checkpoint for the job, what about the records.

Hi,

we have a scenario like need to populate 2 million records , i need to pass the records at a time 40,000.

how to do it apart from looping concept

Hi,

My file input is like

INPUT OUTPUT
1A3D5G ADG
A2DG57 ADG
&$A#DG ADG
(*AD&G ADG

hot to get the output like that.

Hi,
I have file like

INPUT(Entire row in a single column) only one input column
1,2,3,4,A,B,C,D

but i Required the

OUTPUT(4 rows are in a single column) only one output column
1,2,3,4,A
1,2,3,4,B
1,2,3,4,C
1,2,3,4,D

Please tell me the way to do in the PX