DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 15 matches
Author Message
 Topic: Job from a Query
nibumathewbabu

Replies: 4
Views: 161

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 11, 2018 3:01 pm   Subject: Job from a Query
Thanks Craig for the swift response but there is a small change in requirement

if you see the above query, the value for field A should come from select query, B,C,D,E,F Values will come from a sou ...
 Topic: Job from a Query
nibumathewbabu

Replies: 4
Views: 161

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 11, 2018 12:42 pm   Subject: Job from a Query
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi all,
I got requirement to change the below existing query in to a DS Job

PFB the sample query

INSERT INTO Table_Name (A, B, C, D, E, F, G, H)
VALUES ((SELECT MAX(id) + 1 FROM id_table), ' ...
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 327

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 11, 2018 12:37 pm   Subject: Count Validatation and updation of Job even if it fails
Thanks, I will try and let you know
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 327

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 09, 2018 7:53 pm   Subject: Count Validatation and updation of Job even if it fails
Thanks Craig.
As you suggested I have two links from transformer


Link1: Constraint source count=target count then to target table with update audit table with target count and status in table i ...
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 327

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 09, 2018 12:09 pm   Subject: Count Validatation and updation of Job even if it fails
Thank you for the response. I am fine with first part you suggested.

"and only then abort the job if required"

Could you please specify how to implement above step?
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 327

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 08, 2018 1:35 pm   Subject: Count Validatation and updation of Job even if it fails
Thank you for the response.But I need to write the table count to audit table and if count mismatches i need to fail the job also that is the req
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 327

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 04, 2018 9:06 pm   Subject: Count Validatation and updation of Job even if it fails
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,
This is my requriement

I need to compare file source count with target table count and write the both counts in to an audit table with status Success(If count are equal) or Fail on the oth ...
Resolved
 Topic: RCP with Fixed Width File
nibumathewbabu

Replies: 2
Views: 248

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 04, 2018 8:57 pm   Subject: RCP with Fixed Width File
Thank you Ray
Resolved
 Topic: RCP with Fixed Width File
nibumathewbabu

Replies: 2
Views: 248

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 28, 2017 1:05 pm   Subject: RCP with Fixed Width File
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Dear all,
I have a requirement.
Input File which is a fixed width file contains 6 fields out of that 4 fields need to be loaded in to target DB(fields which needs to be omitted is 3rd and 5th fileds ...
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 04, 2017 12:22 pm   Subject: XML generation Issue
Oops since Its being premium content I cant read it in complete Sad
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 28, 2017 11:36 am   Subject: XML generation Issue
Thank you!
With Peek am getting data.
But XML its not.But in the same folder I am able to create new files using sequential stage.What may be the reasons then
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 28, 2017 9:45 am   Subject: XML generation Issue
I had created another job design as below

Oracle Connector -->Transformer-->XML output

I had followed exactly which is been said here: http://datawarehouse.ittoolbox.com/groups/technical-f ...
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 28, 2017 9:24 am   Subject: XML generation Issue
No I Shall explain further

Job1Oracle-4 rows-->XML_Stage-4 rows-->XMl Ouput Stage

Job2 Oracle-4 rows-->XML_Stage-1 row-->Sequential Stage


In job 1 in the edit assembly of XML st ...
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 27, 2017 2:53 pm   Subject: XML generation Issue
I changed the XSD and added
minoccurs="0" maxoccurs="unbounded
also
Output -> Mappinng of the XML stage and assigned "top" to the name of the output link

Now only one file is generating but ...
 Topic: XML generation Issue
nibumathewbabu

Replies: 12
Views: 952

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 27, 2017 9:30 am   Subject: XML generation Issue
DataStage® Release: 9x
Job Type: Parallel
OS: Windows
For generation of new XML I had created an XSD first then created the job like below
Oracle connector>XML>XML_Output
In the edit assembly of XML stage>XML composer step I choose the option ...
 

 Jump to:   



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