DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 22 matches
Author Message
 Topic: Altenate way of parameter passing to a sequence job
nibumathewbabu

Replies: 5
Views: 192

PostForum: General   Posted: Fri Jun 22, 2018 7:41 am   Subject: Altenate way of parameter passing to a sequence job
I did not understand the point you told

the ask is is there any way to pass parameters into sequence with out hard coding and not much disturbing existing sequence
 Topic: Altenate way of parameter passing to a sequence job
nibumathewbabu

Replies: 5
Views: 192

PostForum: General   Posted: Thu Jun 21, 2018 7:34 pm   Subject: Altenate way of parameter passing to a sequence job
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a requirement,currently there is an audit mechanism in place which uses a single ETL Audit table for capturing the counts ,filename,path,rej path,table name etc.

All above param values are h ...
 Topic: Datastage and Mongo DB
nibumathewbabu

Replies: 2
Views: 290

PostForum: General   Posted: Tue Mar 20, 2018 2:19 pm   Subject: Datastage and Mongo DB
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,
I uses Datastage 11.5v and a requirement came to connect to Mongo DB to get data from an external source system.When I checked in Palette I could not find Mongo DB stage as well.

Could some on ...
 Topic: ODBC Connector issue
nibumathewbabu

Replies: 7
Views: 711

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 19, 2018 3:07 pm   Subject: ODBC Connector issue
I believe the issue is with some invisible characters in the source file,requested new file to check,thanks for all the inputs
 Topic: ODBC Connector issue
nibumathewbabu

Replies: 7
Views: 711

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 14, 2018 7:56 am   Subject: ODBC Connector issue
Hi ArndW ,
The deadlock issue got resolved as I put No Lock clause in the input query
As I said,Target Tables dont have any keys or idnices defined and we cant do it as well

Hi Kumar,

What i m ...
 Topic: ODBC Connector issue
nibumathewbabu

Replies: 7
Views: 711

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Mar 12, 2018 8:50 pm   Subject: ODBC Connector issue
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: ODBC Connector issue
Dear All,

for the last two days I am playing around with ODBC connector to load data

My requirement:If the rows are already existing then update else Insert.

Target DB:Sql Server

Requireme ...
 Topic: Capturing CDC logs into a table
nibumathewbabu

Replies: 3
Views: 532

PostForum: General   Posted: Thu Jan 25, 2018 8:39 am   Subject: Capturing CDC logs into a table
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I have a requirement to capture the CDC logs (ie: number of copy rows, number of rows inserted, number of rows updated/deleted) in to a table. Is there any easy way to achieve this?

Ple ...
 Topic: Job from a Query
nibumathewbabu

Replies: 4
Views: 628

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

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), ' ...
Resolved
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 935

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
Resolved
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 935

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 ...
Resolved
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 935

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?
Resolved
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 935

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
Resolved
 Topic: Count Validatation and updation of Job even if it fails
nibumathewbabu

Replies: 9
Views: 935

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

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
 

 Jump to:   



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