DSXchange

Thanks for the updates.

mouthou,
I have a insert link and other three update/delete links. As per the link ordering and record ordering, these activities need to be performed in sequential order.

Not sure how this is being violated.

anudpETL,
In a batch I am getting around 1 M records.

Transformations are like, the links which perform delete and update will have one record and other insert link will have more records.

So totally 3 links will have one record to target and rest one link has more records for insert.

Point to add all the target activities are happening on the same table.

Hi All, Our parallel job design as below which runs in multiple nodes, Oracle Connector --> Tr (4 Output links)--> Oracle Connector. (4 Links out of Transformer and connected to one target Oracle connector). Transformer and Target Oracle connector runs is sequential mode. In the Oracle connector lin...

Hi All, I was trying to find what exactly happens when admin re indexes a project. For couple of project corrupt issues the solution/work around was given in the IBM support docs as to re index the DS project, but no details to tell what exactly happens or what is the output of the re index option. ...

Hi All,

Is it possible to filter parallel jobs based on their NLS setting. For example i am trying to get list of jobs in my project having the NLS setting as "UTF-8".

TIA.

Is there a Islower case function in DataStage? - Updating the subject line - Sorry this should be the subject line. that is the typo error.

Hi All,

My job design is as below,

Oracle connector --> Transformer --> DataSet

Id Varchar(10)

I have requirement where if get records with "id" field in lower case i need to drop those records. Please let me know how can i perform that in DS.

TIA.

One more finding, When i keep the "id" field as the last field in the transformations it is working fine with key field as "type". Now i am getting all the "type" data and corresponding id field also populated correctly. Before "id" was the first field in the ...

Hi All, My xml file look like below, <Parent> <Id>A1</Id> <Sid>A1id</Sid> <Group> <lov type="time"> <id1>1</id1> <desc>US</desc> </lov> <lov type="loc"> <id1>2</id1> <desc>US</desc> </lov> </Group> </Parent <Parent> <Id>B1</Id> <Sid>B1id</Sid> <Group> <lov type="time"> ...

Hi, Thanks for your reply. But in DB, i have the postal code field as LATIN. Below is my table script. My issue is, since i have UTF-8 at job level now, i am getting this abort. If i have LATIN1_0A the job fails for the filed "Id". So in either case my job aborts and i am getting the data ...

RDBMS code 6706: Field POSTAL_CODE (CC_TeraAdapter::SelectLoadErrorTable1, file CC_TeraAdapter.cpp, line 7,721)

POSTAL_CODE field is of type latin in the target table.

Hi All, Our job design is as below, Dataset --> Transformer --> Teradata connector. We are having both Latin and Unicode character set fields in the target table. Currently in job level and Teradata connector we have the NLS setting as UTF8. The job works only if we get Unicode character and gets ab...

Hi All, My job design is as below. External source(List of file names received) --> XML input(URL option) --> Dataset. In XML input stage we have transformations as below, /Top/Cust:Customer/Cust: Flag /text() This transformation works fine when the input files proper. But in some cases in the sourc...

Thanks for the input.. Created a sample job and tried. It is work in overwirte move mode itself as expected..

Thanks.