DSXchange

Hi,

Good thing about using parallel job is Performance!! even with sequential mode.

I have tested a job with the above routinue and it really gives good performance.

Source : Oracle
Volume : 150,000 records
Time Taken : 2 min

Steps: 1. Use the above code and create a file "Filename.c" 2. Compile the above file using value available in APT_COMPILEROPT and APT_COMPILER something like this below, g++ -c -O -fPIC -Wno-deprecated -m64 -mtune=generic -mcmodel=small 3. Now u can see a new file with "filename.o&qu...

Hi, I have created a C++ routinue for creating dynamic flat files, Insert each record into the file. logic: Chk for the file name; If exists then append the row Else create new file. This routine works only ehn the transformer is set to sequential process. attachString -- > set of delimited column v...

Hi, Currently we are trying to fetch 10 million records from oracle (it may grow) and to creating a flat file. In between, and need to get the description from the master using lookup. The jobs is running fine without any problem. But the problem is, the scratch disk is getting full (20 gb) for just...

Seq File --> Xfm1 --> Sort1 stg --> xfm2 --> output Xfm1 --> using stage variable count all the records and pass it to new column ( Count1) Sort1 stg --> Sort all the records based on Count1 column in decending order xfm2 --> put constraint to pass only first and last record ( constraint ==> INROWNU...

Can you please tell me how to implement with XML pack 2. Is it through expression to be hard coded using transformer stage or the XML stage supports this property.

Hi All, My requriment is to validate the XML based on the XSD schema. Is it possible to impelement in our datastage job. Sample XSD schema below; The reference element "Activity" is a user defined element "ActivityDataType" and it has list of restricted values as highlighed below...

Hello, We will have to migrate from DB2 to Oracle.The current data stage version is 7.1.Could you please let me know which version(s) of oracle is compatible with DS 7.1?are 10g and 11g compatible with DS 7.1? Thanks in advance Datstage 7.1 can support any version of oracle, if the plugin for that ...

Hi,

Use the Sequencer jobs to run the job and now you can use the below function to define as paramter for the job.

Ereplace(Oconv(@DATE,"D-YMD[4,2,2]"),'-','')

This function will return the system date without '-' (e.x. YYYYMMDD).

Let me know i foyu need anything more.

Hi, Create 2 stage variable for contactinating date and time rather than writing routine. In this below rule the time can have more than 2 digit as Hour (ex: 150:00:60). Lets us assume the input variable as below vDate = Date format vTime = time format **svDays stage variable calculates the no of da...

Hi,

First make sure that the windows scheduler on the datastage server is enabled. If not request you Admin to enable the windows scheduler and then try through datastage.

Please check the below site,

http://www.diskdatarecovery.net/unix-data-recovery

Hi,

When ever you use "Remove Duplicate" stage, the incoming data should be sorted. As per your design, i don't think your imcoming are not properly sorted. Please try to sort the row before the "Remove Duplicate" stage.

Hi Ray,

I am really sorry. I really didn't mean to say that.

Hi,

Try to increase array size in hte OCI stage to 10,000. This will help to increase the performance.