Search found 26 matches
- Mon Jun 10, 2013 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborted when no file found
- Replies: 5
- Views: 2804
Re: Job aborted when no file found
Please set the "Missing File Mode"="OK" under File Properties->Options
- Fri Nov 25, 2011 3:03 am
- Forum: General
- Topic: to find the last update timestamp of a job
- Replies: 4
- Views: 3182
- Mon Nov 14, 2011 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: If value is negative need to make it default 0(zero)
- Replies: 4
- Views: 2578
- Wed Oct 19, 2011 5:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data getting set to zero
- Replies: 9
- Views: 5677
- Tue Sep 06, 2011 1:40 am
- Forum: General
- Topic: Unable to save XML table definition
- Replies: 1
- Views: 1964
Unable to save XML table definition
I am able to see the XML file but unable to save XML table definition in XML Meta Data Importer.
The save button in File tab is in Disable stage.
What is the reason for this?
The save button in File tab is in Disable stage.
What is the reason for this?
- Mon Aug 29, 2011 5:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem with compare stage
- Replies: 4
- Views: 4948
Re: problem with compare stage
Mr Devendra, This is very simple. Don't add any columns to the compare stage output page and Enable Runtime column propagation , then datastage itself will decide the column names and insert the data into your target file. Your target columns will be Result+first file columns+second file columns Dat...
- Tue Aug 23, 2011 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation
- Replies: 1
- Views: 1931
Re: Calculation
Take three stage variables A,B,C
and calculate column D using the logic : D= A-B-C .
Or why can't you do the calculation directly as below
D=a+b-e-r-t-p-t-y-p-u
and calculate column D using the logic : D= A-B-C .
Or why can't you do the calculation directly as below
D=a+b-e-r-t-p-t-y-p-u
- Tue Aug 02, 2011 5:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to load "2011-02-02T14:05:35" to Timestamp co
- Replies: 5
- Views: 3095
- Thu Jul 14, 2011 5:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in Change Capture stage
- Replies: 2
- Views: 2674
- Thu Jul 14, 2011 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in Change Capture stage
- Replies: 2
- Views: 2674
Need help in Change Capture stage
I have requirement like below
Before File:
Key Non_Key
1 a
2 b
3 c
After File:
Key Non_Key
1 a
2 d
4 e
Then how many records i will get after ChangeCapture stage and what is the value of the "ChangeCode()" field ?
Before File:
Key Non_Key
1 a
2 b
3 c
After File:
Key Non_Key
1 a
2 d
4 e
Then how many records i will get after ChangeCapture stage and what is the value of the "ChangeCode()" field ?
- Wed Jun 01, 2011 3:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic Required
- Replies: 9
- Views: 9225
Process your records into two flows main flow and changed flow In changed flow use aggregator and find the count by grouping on key, your output from aggregator will be key,count then use join stage and join main flow and changed flow records based on key and return count from changed flow(from aggr...
- Wed Jun 01, 2011 3:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage scenario
- Replies: 3
- Views: 11119
Re: Datastage_scenario
Hi,
join File1 and File2 using joiner stage with the key cust_id and return the two columns cust_name, sales_amount .
Please let us know if it is not working
Thanks,
Sreekanth
join File1 and File2 using joiner stage with the key cust_id and return the two columns cust_name, sales_amount .
Please let us know if it is not working
Thanks,
Sreekanth
- Tue May 31, 2011 12:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: need help in logic
- Replies: 9
- Views: 9902
Connect your source to Aggregator and put group by on ID and do SUM and MAX and connect these three columns(ID,sum_value,max_value) to trasformer. In Trasformer calculate DIFF using the logic ABS(max_value*2 - sum_value) , here ABS function used to get the positive value and connect three fields(id,...
- Mon May 30, 2011 6:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header and footer identification in a sequential file
- Replies: 2
- Views: 3873
As you said use the Row Number Column in the Sequential File stage. Then all your input records will be having Row_number Connect Sequential File stage to transformer and use @INROWNUM to get the total count then connect the transformer to Filter stage there you put a condition like Row_number=1 or ...
- Sun May 29, 2011 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data insert multiple times in target database
- Replies: 9
- Views: 6100