Search found 99 matches
- Tue Sep 27, 2016 5:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to read hashed file in basic
- Replies: 9
- Views: 10753
- Thu Jul 21, 2016 5:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unstructured Data with big number
- Replies: 7
- Views: 9010
- Tue Jul 12, 2016 11:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unstructured Data with big number
- Replies: 7
- Views: 9010
Hello chulett, thank you for your reply. I tried to find here the solution before I posted this question, but in my case, I cannot create a calculation because in this column I have numbers, date, string. So I need to read without this conversion. Is it possible? If I open this excel I see the corre...
- Tue Jun 21, 2016 10:26 am
- Forum: IBM QualityStage
- Topic: PAL - How to pick up the text between the brackets []
- Replies: 5
- Views: 18327
- Mon Jun 20, 2016 8:34 am
- Forum: IBM QualityStage
- Topic: PAL - How to pick up the text between the brackets []
- Replies: 5
- Views: 18327
- Mon Oct 27, 2014 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to create this PIVOT
- Replies: 2
- Views: 3437
- Mon Jul 21, 2014 1:42 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Job run *FAILURE* in 1440 minute(s) 2 seconds
- Replies: 6
- Views: 6694
This is the IA Log the DataStage director log is very large. If you want I can put here. IA Job Status -------------------------------------------------------------------------- | Job Execution Status -> DPVAT_CHASSI77791107 | | JOB TYPE : com.ascential.investigate.ca.job.BaseProfileJob | | JOB PRO...
- Mon Jul 21, 2014 11:36 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Job run *FAILURE* in 1440 minute(s) 2 seconds
- Replies: 6
- Views: 6694
Job run *FAILURE* in 1440 minute(s) 2 seconds
Hello, I am analyzing a very huge table and after 24 hours, it is failing with timeout error. Job run *FAILURE* in 1440 minute(s) 2 seconds. This error occur in more than one column, and always after 1440 minutes or 24 hours, so I would like to know if there are some way to increase this period. Tha...
- Fri Jul 18, 2014 12:36 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to clean the IADB
- Replies: 2
- Views: 5108
- Fri Jul 18, 2014 5:14 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: How to clean the IADB
- Replies: 2
- Views: 5108
How to clean the IADB
Hello everybody, I am here aging needing help, this time with the Information Analyse. This week I am creating many analyses column from my tables and then I am creating 3 reports for each table analyzed. I have analyzed many tables but I need to analyze more than 300 tables yet. My problem is the I...
- Fri Jun 14, 2013 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute the storage procedure sp_who and get all output colu
- Replies: 3
- Views: 2657
- Fri Jun 14, 2013 5:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Execute the storage procedure sp_who and get all output colu
- Replies: 3
- Views: 2657
Execute the storage procedure sp_who and get all output colu
Hi guys, I am creating a job to execute the procedure sp_who in my SQL Server. This is an internal procedure from SQL Server which show us many information such as spid, ecip, status, logingname, hostname, blk, dbname, cmd and requestid . In my first test I am using the stage Stored Procedure. The j...
- Tue Dec 18, 2012 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Which partition type I need to use in the JOIN stage
- Replies: 7
- Views: 5876
- Tue Dec 18, 2012 4:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Which partition type I need to use in the JOIN stage
- Replies: 7
- Views: 5876
Which partition type I need to use in the JOIN stage
Hi guys, someone could help me? I need to do a JOIN, so I usually do this in two ways. 1. I select the patition type as Hash and I select my keys. I do this in both links (in the main link and in the reference link) 2. I select the partition type as Round robin in my main link and I select the parti...
- Sun May 13, 2012 6:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Week number in the month
- Replies: 14
- Views: 11447
Week number in the month
Hi guys, I need your help. I know the function YearweekFromDate, this function returns the week number in the year from the given date, but now I need to know some function or logic that return to me the week number in the month. Following the example: September 2012 Sunday | Monday | Tuesday | Wedn...