Hi,
We have a generic script which used to load runbatch.sh or runbulkprocess.sh in the RDM server. I am still exploring the same on how to upload or download Dataset in RDS.
will keep you posted on the same.
Regards,
S.R
Search found 182 matches
- Tue Jan 21, 2020 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Infosphere Reference Data Management Hub Data load
- Replies: 2
- Views: 4390
- Sun Jan 19, 2020 8:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Infosphere Reference Data Management Hub Data load
- Replies: 2
- Views: 4390
Infosphere Reference Data Management Hub Data load
Hi All,
Is there any way we can load the reference tables directly into Infosphere RDM using command line or any other method to create a new set followed by importing table data into the same?
Kindly let me know your thoughts.
Regards,
S.R
Is there any way we can load the reference tables directly into Infosphere RDM using command line or any other method to create a new set followed by importing table data into the same?
Kindly let me know your thoughts.
Regards,
S.R
- Wed Jan 15, 2020 9:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle huge historical record loads in Azure DataLake
- Replies: 2
- Views: 4221
- Sat Jan 11, 2020 7:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle huge historical record loads in Azure DataLake
- Replies: 2
- Views: 4221
How to handle huge historical record loads in Azure DataLake
Hi All, We have a scenario that we have to load 500 million historical records from sql server to Azure data lake followed by 200k daily/incremental records data to capture the changed records and then we will need to load into data lake. The catch here is we don't have timestamp columns. We are loo...
- Fri Sep 21, 2018 6:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find difficulty to convert Case into IF else logic
- Replies: 1
- Views: 2174
Find difficulty to convert Case into IF else logic
Hi All, I am finding difficulty while converting the below case statement into the IF else logic to use it into a constaraint while calculation the below scenario..especially with huge amount of data. I tried implemented at source query level, it work for minimal amount of data. CASE WHEN a.Id=2 THE...
- Sun Sep 16, 2018 6:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation of DeliveryDate while building Fact
- Replies: 9
- Views: 5383
- Sun Sep 16, 2018 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation of DeliveryDate while building Fact
- Replies: 9
- Views: 5383
Hi All, Please let me know on how to acheive he below logic... I will make as CreateDate +2 for initial order and CreateDate +3 and so on until if it doesn't falls on my Holiday table.... If i won't find that it in my Holiday table i would like to take that date as my Delivery date...as i have Creat...
- Sat Sep 15, 2018 3:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation of DeliveryDate while building Fact
- Replies: 9
- Views: 5383
- Fri Sep 14, 2018 10:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation of DeliveryDate while building Fact
- Replies: 9
- Views: 5383
- Fri Sep 14, 2018 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculation of DeliveryDate while building Fact
- Replies: 9
- Views: 5383
Calculation of DeliveryDate while building Fact
Hi All, I have a business scenario or transformation logic to populate DeliveyDate/ReqiuredDate for an order item. If a Delivery date is null for the order item, i have to calculate the below logic in DS. Delivery date is NULL, Get the Creation Date and add +2 days with them to make it as delivery d...
- Mon Sep 10, 2018 9:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset to Oracle DB load error
- Replies: 4
- Views: 3730
- Mon Sep 10, 2018 7:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset to Oracle DB load error
- Replies: 4
- Views: 3730
Hi Craig, When i tried to generate sql at run-time..i could see the below warnings. But, i have been mapped to the target by using copy stage. The column Col2 from the input schema is not used. It will be ignored. The columnCol3 from the input schema is not used. It will be ignored. Note: For me, i ...
- Mon Sep 10, 2018 4:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset to Oracle DB load error
- Replies: 4
- Views: 3730
Dataset to Oracle DB load error
Hi All, I could see the below error while loading the data from Dataset into Oracle table. The variable nAccessorIndex has value -2 which is not valid in the current context. (CC_OraRecordDataSetConsumer::getAccessor, file CC_OraRecordDataSetConsumer.cpp, line 5,783) The runLocally() of the operator...
- Thu Sep 06, 2018 11:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find previous business day
- Replies: 7
- Views: 4278
- Thu Sep 06, 2018 8:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error message: ORA-01858: a non-numeric character was found
- Replies: 6
- Views: 5120