DSXchange

Hi Ray,

Apart from the above warning I am getting below warning :

MERGE..Transformer_17.DSLink22: ds_ipcopen() - Error in mmap(/tmp/ade.dpr_eim_dev.MERGE..Link_Partitioner_20-Transformer_17.DSLink22) - Not enough space

Can you give what is the solution for this.

Regards,
Arshi

Hi,

This is the below warning I am getting .

Unable to open ODBC trace file ?+??/sysp/DataStage/Ascential/DataStage/branded_odbc/lib/odbctrac.so
DataStage Job 12 Phantom 24758
Job Aborted after Fatal Error logged.

Regards,
Arshi

Hi,

Is it compulsary required SMP systems to impliment Link collector and Partition logic? Because If I ran on single processor system the job was giving some problem.
Any one knows please explain about this.

Regards,
Arshi

Hi Ray,

Can you please explain it.I am unable to understand.

Regards,
ARSHI

Hi,

I am unable to get through Aggregator because data is in timestamp format.So,unable to add.

Regards,
Arshi

Hi,

How to develop the logic ,I have a table with columns (EmpNo,Ename,Join Time,DeptNo).I have to sum up all the employees join timein all the departments.This Jointime column datatype is Timestamp.

regards,
Arshi

Hi,

File Format: File Name-ddmmyyyy.csv

From this file how do I pass #FileName# in the below code

Code:
MONTH.LAST(Iconv(DIGITS(#FileName#),"DDMY")) .

Regards,
Arshi

is there any other way?

Hi,

I am facing problem in the date extraction from source file.

Source File Format : File Name-21082008.xls

From this source file I need to extract 'Last day of the month' and populated into the Target column.

How to implement this.

Regards,
Arshi

Hi,
How to convert the source data for one column 'June 2006' to 'Jun-06'.
The datatype for this column is Varchar,
Is it required to write a routine for this.

Regards,
Arshi

Hi,
Can we run parallel jobs on windows environment?is the unix compulsary to run the jobs?

Regards,
Arshi

Hi Hemant,

The problem here is at View Data of Oracle OCI stage.i.e, as I mentioned earlier the message given as "OCI DATE Conversion Failed" for particular dates lessthan '01-JAN-2001'.
All the Dates populated correctly into the target oracle table.

Regards,
Arshi

Hi DSguru2B and gateleys,

Length of the date field is 11 in the table.One of the source file date data is 13-AUG-1996.

Regards,
Arshi

Hi, In my job I am using Oracle OCI stage.If I click view data its giving the message as "OCI DATE Conversion Failed".But the data is populated correctly into target oracle table. If I remove the date data(lessthan '01-JAN-2001') in the source(flat file) then it not showing that message.An...

DSGuru2B, In the design of the job TRANS1 have ODBC lookup and TRANS2 have ODBC lookup.In this post it not showing correctcly Design: ODBC ------->>TRANS1------>TRANS2----->ODBC ^ ^ | | | | | | 0DBC ODBC (lookup) (lookup) At TRANS1 its aborted.