DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 147 matches
Author Message
 Topic: Automated Tool for ETL Testing/Validation
shamshad

Replies: 5
Views: 2484

PostForum: General   Posted: Tue Aug 08, 2017 1:43 am   Subject: Automated Tool for ETL Testing/Validation
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: DataStage and Informatica
We primarily use DataStage 8.5/11.5 for our data integration needs and soon will also be using Information. Currently all our ETL testing are manual.

I am looking for tools/softwares that can be us ...
 Topic: Automatic deployment of DSX from one environment to another
shamshad

Replies: 1
Views: 1163

PostForum: General   Posted: Tue Jul 18, 2017 8:41 am   Subject: Automatic deployment of DSX from one environment to another
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
At this time we migrate the dsx code from one environment to another by exporting and importing dsx code and compiling them manually. The dsx is first sent to ACCUREV for version control and then migr ...
Resolved
 Topic: Read and update db2 table in same job
shamshad

Replies: 2
Views: 2200

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 21, 2011 7:00 pm   Subject: Read and update db2 table in same job
Lets assume that even if there won't be a deadlock issue, why would you want to have a job that reads and update the same table? Isn't one of the best practice is to separate each database operation ( ...
Resolved
 Topic: Date and Number validations
shamshad

Replies: 6
Views: 1927

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 21, 2011 6:56 pm   Subject: Date and Number validations
Can there be 2 routines, one for DATE CHECK and one for NUMBER CHECK. Just pass the column value to the routine and get either a value or NULL as OUTPUT. Then insert into table.
 Topic: Get next value from DB Seq
shamshad

Replies: 20
Views: 5773

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 21, 2011 6:53 pm   Subject: Get next value from DB Seq
Even if you are using multiple node, you can force the file to be read sequentially so that each row gets the next value. Look into the file property and there is a setting to read it sequentially
 Topic: ascii to ebcdic or ebcdic to ascii translation
shamshad

Replies: 5
Views: 1661

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 21, 2011 6:49 pm   Subject: ascii to ebcdic or ebcdic to ascii translation
Are you downloading the file from mainframe system?
 Topic: Restartability mechanisms
shamshad

Replies: 31
Views: 11508

PostForum: General   Posted: Fri Nov 04, 2011 7:28 am   Subject: Restartability mechanisms
This is more of a logical design rather than using the tool to get the job done. Once you extract data from source, check what rows doesn't exist in target and only "insert" new rows.

In first run ...
 Topic: Has any one used Teradata BTEQ in Datastage 8.5?
shamshad

Replies: 0
Views: 1228

PostForum: General   Posted: Tue Nov 01, 2011 11:59 am   Subject: Has any one used Teradata BTEQ in Datastage 8.5?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Need to know if anyone has used Teradata BTEQ script in Datastage 8.5 and came across any issues?
Resolved
 Topic: Passing password parameter to DB2 Stage via Sequence
shamshad

Replies: 8
Views: 6629

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Aug 04, 2010 12:36 pm   Subject: Passing password parameter to DB2 Stage via Sequence
Password file is just a plain text file that contains the password. It is stored on the ETL Server. If Datastage has access to a particular directory you can create it yourself.
 Topic: is the any possible of passing parameter value
shamshad

Replies: 10
Views: 4523

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 26, 2009 9:37 am   Subject: is the any possible of passing parameter value
I assume what Tej needs has been already answered by MK.
I would make no such assumption, especially considering the questions asked so far and the shear amount of guessing going on in what is being ...
 Topic: sort key problem
shamshad

Replies: 4
Views: 1477

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 26, 2009 9:04 am   Subject: sort key problem
Martin,

This might not be the answer you looking for but whenever we have to sort and rearrange huge amount of data, we do it via a UNIX script rather than using the ETL Tool.

UNIX does these o ...
 Topic: is the any possible of passing parameter value
shamshad

Replies: 10
Views: 4523

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 26, 2009 8:57 am   Subject: is the any possible of passing parameter value
I assume what Tej needs has been already answered by MK.

If you are processing some logic in the first Sequence/Job and the result of the first Sequence needs to be passed to the Second Sequence, ...
Resolved
 Topic: Loading Timestamp To SQL Server 2005 datetime
shamshad

Replies: 5
Views: 2180

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 23, 2009 4:02 pm   Subject: Loading Timestamp To SQL Server 2005 datetime
May be worth trying this

(1) First HardCode Timestamp value and insert in target table and see if
jobs runs successfully.
(2) If it works fine, treat your input timestamp as character column ...
Resolved
 Topic: Passing password parameter to DB2 Stage via Sequence
shamshad

Replies: 8
Views: 6629

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Jan 08, 2009 11:16 am   Subject: Passing password parameter to DB2 Stage via Sequence
Since you are mentioning that when hardcoding from UNIX works, I bet you it's the password file or the parameter file that you have created for DB2 password. Even though the password looks fine, it mi ...
Workaround Reported
 Topic: oracle fetch child records
shamshad

Replies: 4
Views: 1835

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 15, 2008 2:19 pm   Subject: oracle fetch child records
If you are allowed to create a temporary table in Oracle, dump the dataset data into a table where the child oracle table resides and then push down the join operation as SQL between both tables, the ...
 

 Jump to:   



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