DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 190 matches
Author Message
 Topic: First record populating while using XML stage
deesh

Replies: 1
Views: 160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 23, 2018 1:52 am   Subject: First record populating while using XML stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I am trying to extract the data from xml file, i tried with the one of the online file (books xml file) with the XML stage, retrieving only the first row and remaining rows are not populating a ...
 Topic: RCP error with schema files and updates
deesh

Replies: 2
Views: 261

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 02, 2018 5:15 am   Subject: RCP error with schema files and updates
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

I too facing same issue [url=www.dsxchange.com/viewtopic.php?t=148292] as noted here. Using RCP in my job without defining the columns in job , executing the job with schema files, if i use onl ...
 Topic: Records are not populating while Using RCP in job
deesh

Replies: 2
Views: 365

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 27, 2018 3:04 am   Subject: Records are not populating while Using RCP in job
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

We are trying to pull the data with different metadata, for that taken below steps.
1. Sequencial file --> providing file, schema_file and enable RCP
2. Transformer -- > enabled RCP and ...
 Topic: XML file, one xsd call internally one more xsd
deesh

Replies: 2
Views: 464

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: 598

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: 598

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: 714

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: 1035

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: 749

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: 1145

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: 700

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: 1145

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: 842

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: 1501

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: 1501

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)
 

 Jump to:   



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