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
Search found 22 matches
- Fri Jun 22, 2018 7:41 am
- Forum: General
- Topic: Altenate way of parameter passing to a sequence job
- Replies: 5
- Views: 4043
- Thu Jun 21, 2018 7:34 pm
- Forum: General
- Topic: Altenate way of parameter passing to a sequence job
- Replies: 5
- Views: 4043
Altenate way of parameter passing to a sequence job
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 hard coded into the Audit insert sequence job (which resides in the main sequence job);Now the requireme...
- Tue Mar 20, 2018 2:19 pm
- Forum: General
- Topic: Datastage and Mongo DB
- Replies: 2
- Views: 2608
Datastage and Mongo DB
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 one help me to understand how to connect to Mongo DB from datastage?
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 one help me to understand how to connect to Mongo DB from datastage?
- Mon Mar 19, 2018 3:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector issue
- Replies: 7
- Views: 5654
- Wed Mar 14, 2018 7:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector issue
- Replies: 7
- Views: 5654
- Mon Mar 12, 2018 8:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector issue
- Replies: 7
- Views: 5654
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 Requirement constraint: Cant add primary keys or index in target DB as it is being already used in front end,hence no key...
- Thu Jan 25, 2018 8:39 am
- Forum: General
- Topic: Capturing CDC logs into a table
- Replies: 3
- Views: 2582
Capturing CDC logs into a table
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?
Please suggest options.
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?
Please suggest options.
- Thu Jan 11, 2018 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job from a Query
- Replies: 4
- Views: 3502
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 source file columns G,H will be again from transformer(Hard coded) The whole idea is there are some fields...
- Thu Jan 11, 2018 12:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job from a Query
- Replies: 4
- Views: 3502
Job from a Query
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), '', 5, 'ABBEY', '', 1, 1, 'EFG'); How can I achieve inserting the first value(select query from a table) using ...
- Thu Jan 11, 2018 12:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count Validatation and updation of Job even if it fails
- Replies: 9
- Views: 5141
- Tue Jan 09, 2018 7:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count Validatation and updation of Job even if it fails
- Replies: 9
- Views: 5141
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 is success Target DB stage Read committed,Record Count and Array size=1 Link 2 Constraint source count <> ta...
- Tue Jan 09, 2018 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count Validatation and updation of Job even if it fails
- Replies: 9
- Views: 5141
- Mon Jan 08, 2018 1:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count Validatation and updation of Job even if it fails
- Replies: 9
- Views: 5141
- Thu Jan 04, 2018 9:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count Validatation and updation of Job even if it fails
- Replies: 9
- Views: 5141
Count Validatation and updation of Job even if it fails
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 other case and I also need to fail the job if count mismatch is there. The issue I face is,If we try to ach...
- Thu Jan 04, 2018 8:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP with Fixed Width File
- Replies: 2
- Views: 2404