DSXchange

@PARTITIONNUM + (@NUMPARTITIONS* @INROWNUM)

Why do we want to go in a black hole and that too on ETL?

still i would say try start loop from 1 and make it incremental loop and end it on 0 so that will never meet condition and it will be an infinite loop. But mind it, it will screw resources....................

Hi, i was looking for the return code of the dsimport commnad in windows command prompt. As i am always getting 0 as a return code. Even if lets say the dsx file to be imported has a wrong name there is a window pop up comes up (thats ideally a dsimport windows interface). But if you hit cancel to i...

I would suggest 2 things:
1. While using DS 7.5.2 we faced rounding of problem thats was resolved by patch for datastage. So you can first use a peek or temporary file to check what data is going to be loaded.

2. Check with the DBA about the NLS setting of the target.

:-)Sunil

HI, How can i access the DS_METADATA file present in my project folder. Besides that can anybody help me how can we write the metadata of a imported definition to a sequential file. I am able to access hash file now but still i cant locate the metadata of the elements of the definations i imported ...

HI,
How can i access the DS_METADATA file present in my project folder.
Besides that can anybody help me how can we write the metadata of a imported definition to a sequential file.

hi,
how can i have time zone(as pst,ist) in timestamp and have the time in GMT in parallel jobs?

hi,
how can i have time zone(as pst,ist) in timestamp and have the time in GMT in parallel jobs?

hi dssiddu

as Comp3 is reqired a output henc cff is not fruifull as it dont give output.


Thanks
Sunil

Hi to all, Ya this is a place to share!!!!!! As i got the solution from here itself while reading some other articles. Thanks to all... Well the job which i was trying to create goes as with foll things: 1. For XML INPUT : Input : Stream data (XML doc) Output: Sequential data. 2. For Xml Output: Inp...

Hi all,
Well i am done withj above problem.

Thanks
Sunil

Add to above i have a structure like FOLDER -----> XML Input -----> Transformer (processing not Xml one)---->Seqential file Now Folder to Xml is working fine but Input stage is not converting it to sequential output and throwing an error: "Text can only occur as a direct child of a "column...

HI all, Is it possible to extract just 1 record from an XML as i need to check the condition on that record and then make further transformation. I am able to take XML as input and able distribute them on the basis of there file name but i need to check a data (a field value in heirarchical structur...