DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 187 matches
Author Message
 Topic: XML file, one xsd call internally one more xsd
deesh

Replies: 2
Views: 179

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 01, 2018 9:01 pm   Subject: XML file, one xsd call internally one more xsd
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,
I have XML file, which contains two xsd's columns, no idea how to work with two xsd's .

one xsd calling internally one more xsd.
Resolved
 Topic: Getting more records while using lookup
deesh

Replies: 3
Views: 223

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 30, 2018 7:15 pm   Subject: Getting more records while using lookup
From reference getting distinct records.
Resolved
 Topic: Getting more records while using lookup
deesh

Replies: 3
Views: 223

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 30, 2018 9:07 am   Subject: Getting more records while using lookup
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.

Using continue( left join), if we mention continue output should mat ...
 Topic: execute ds job through command line with env file
deesh

Replies: 5
Views: 427

PostForum: General   Posted: Wed Nov 01, 2017 1:09 pm   Subject: execute ds job through command line with env file
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi, I am trying to execute the ds job through command line.

when i am trying include the parameter set in the command line job is triggering, but if i include env variables in the command line job ...
 Topic: Reading multiple xlsx files
deesh

Replies: 3
Views: 754

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 09, 2017 5:51 am   Subject: Reading multiple xlsx files
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

My requirement also same like [url=http://www.dsxchange.com/viewtopic.php?t=156727]this requirement, getting multiple .xlsx files.
Can i know how the template looks?

My requirement :

1. ...
 Topic: How to load encrypted data into netezza
deesh

Replies: 1
Views: 547

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 07, 2017 9:06 am   Subject: How to load encrypted data into netezza
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We are trying to load the encrypted data into netezza, but getting error due to bad rows.

Can some one tell me how to load encrypted data into netezza.

First we are loading data from ora ...
Resolved
 Topic: get file date as column value
deesh

Replies: 2
Views: 903

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 19, 2017 11:42 am   Subject: get file date as column value
Achieved by the file name column property in sequential file stage
 Topic: How to pass multiple files through looping activity
deesh

Replies: 2
Views: 532

PostForum: General   Posted: Wed Apr 19, 2017 11:40 am   Subject: How to pass multiple files through looping activity
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi, i am getting multiple files with the common structure, but my senior saying need to use the loop activity in sequence jobs and solve the issue.

Please let me know how to resolve by using start ...
Resolved
 Topic: get file date as column value
deesh

Replies: 2
Views: 903

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 10, 2017 9:49 pm   Subject: get file date as column value
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field.

Could you help how to reach, Moreover wi ...
 Topic: Getting Host key verification failed while executing the DS
deesh

Replies: 2
Views: 592

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 22, 2017 8:42 am   Subject: Getting Host key verification failed while executing the DS
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi
Getting Host key verification failed while executing the DS through unix
Please let me know in which scenario getting the issue, and whtat is the solvation.
main_program: APT configuration ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 1338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 22, 2017 6:24 am   Subject: String to decimal, unable to get proper data
I found the issue i am getting the control M char for that field and used below logic to remove the control and removing first three header rows in the file.

used External source stage

tail -n + ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 1338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Mar 18, 2017 10:25 am   Subject: String to decimal, unable to get proper data
Yes, seeing the results in peek stage.
Source data type string and target data type decimal(15,10)
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 1338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 8:36 pm   Subject: String to decimal, unable to get proper data
Please find below what are the option I tried.

Trim(column,' ','A')-- result '0.0'
String to decimal(trim(column))-- result '0.0'
Field(column'.','1') -- result ' 00100'
Field(column,'.','1'):'. ...
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 1338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 11:29 am   Subject: String to decimal, unable to get proper data
Yes converting the data ' 100.0' to '0.0' while doing string to decimal
Resolved
 Topic: String to decimal, unable to get proper data
deesh

Replies: 13
Views: 1338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 17, 2017 7:55 am   Subject: Re: String to decimal, unable to get proper data
I have modify the statement, is above one is ok (no confused) --craig
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours