DSXchange

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

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

Hi asorrell,

Thanks for your response. I am also on the same road. No change / source will not be modified.



Regards,
Satheesh.R

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...

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...

Great Thanks Craig & Ray !!!


I have done / achieved the result by taking CreateDate + 2, CreateDate+3,....until CreateDate+7(Max 7 Days from the order CreatioDate as per the Business) and lookedup against Holiday Table and fetch the DeliveryDate


I looks good as of now !!!




Regards,
S.R

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...

Hi Ray, Yes..Some kind of..We have built a Holiday table for all the regions(US,UK,APAC,ANZ)...which contains Holiday Dates includes national holiday and non-business days(Sat & Sun). If my Deliverydate is null i have to create the DeliveryDate based on Invoice creationDate + 2 Days which should...

Hi Craig,

You are absolutely with me.....Yes.






Thanks.
S.R

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...

Hi Craig, Thanks for your valuable time on this and i apologize for wasting your time. I have found out the issue with one of the column name "mispelled", when i try to create user-defined insert statement. It took almost 4 hrs to identify the issue..:(. Now the issue is to fill the Task t...

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 ...

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...

Hi All, Appreciate for your information. Currently we are building CalendarHoliday table for different regions(US/UK & ANZ)...which includes public holidays and weekends(Sat&Sun). Once this gets done we will do a lookup against the table to get the required date. Basically we are looking to ...

Hi,

Thanks Craig. Now i have changed the datatype as varchar(96) and the issue gets resolved.






Thanks.