Search found 147 matches
- Tue Aug 08, 2017 1:43 am
- Forum: General
- Topic: Automated Tool for ETL Testing/Validation
- Replies: 5
- Views: 5384
Automated Tool for ETL Testing/Validation
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 used to "AUTOMATE ETL TESTING" mainly for Datastage and Informatica. Any suggestion will be app...
- Tue Jul 18, 2017 8:41 am
- Forum: General
- Topic: Automatic deployment of DSX from one environment to another
- Replies: 1
- Views: 2065
Automatic deployment of DSX from one environment to another
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 migrator will pick up the dsx and move to newer environment. My question is "Do we have ANY tool ou...
- Wed Dec 21, 2011 7:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read and update db2 table in same job
- Replies: 2
- Views: 3116
- Wed Dec 21, 2011 6:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date and Number validations
- Replies: 6
- Views: 3056
- Wed Dec 21, 2011 6:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Get next value from DB Seq
- Replies: 20
- Views: 10965
- Wed Dec 21, 2011 6:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ascii to ebcdic or ebcdic to ascii translation
- Replies: 5
- Views: 3203
- Fri Nov 04, 2011 7:28 am
- Forum: General
- Topic: Restartability mechanisms
- Replies: 31
- Views: 16126
- Tue Nov 01, 2011 11:59 am
- Forum: General
- Topic: Has any one used Teradata BTEQ in Datastage 8.5?
- Replies: 0
- Views: 1926
Has any one used Teradata BTEQ in Datastage 8.5?
Need to know if anyone has used Teradata BTEQ script in Datastage 8.5 and came across any issues?
- Wed Aug 04, 2010 12:36 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Passing password parameter to DB2 Stage via Sequence
- Replies: 8
- Views: 9540
- Mon Jan 26, 2009 9:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: is the any possible of passing parameter value
- Replies: 10
- Views: 6605
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 posted. :? When the question is not very clear and we sort of know what he means I guess we can atle...
- Mon Jan 26, 2009 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sort key problem
- Replies: 4
- Views: 2807
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 operation fairly quickly and efficiently and we never had any memory issues etc. The only catch is you will ...
- Mon Jan 26, 2009 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: is the any possible of passing parameter value
- Replies: 10
- Views: 6605
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, then store all the parameter name and value pair from the First Sequence in a sequential file. Then in t...
- Fri Jan 23, 2009 4:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading Timestamp To SQL Server 2005 datetime
- Replies: 4
- Views: 3788
- Thu Jan 08, 2009 11:16 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Passing password parameter to DB2 Stage via Sequence
- Replies: 8
- Views: 9540
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 might not be !!! I suggest delete the parameter file/ password file and then run your Shell Script wit...
- Wed Oct 15, 2008 2:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle fetch child records
- Replies: 4
- Views: 3092