DSXchange

no idea ..?

I have tried to hash partition on a key column and tried re running the upstream job that creates the datasets. Now i could see in the dataset management utility, where the datasets showing records distributed on both the nodes to have records and load job has completed in 2 seconds. I haven't tried...

Hi , Following is my load job design New_records.ds --------> Funnel ----->Oracle Enterprise stage Update_records.ds -----> 1) the datasets of the load job are created in a two node configuration engine. 2) The upstream job that created the datasets is completely sequential untill the point that wri...

Hi

I have found a function OCONV in the expression editor and used the conversion flag as 'MCN'. This has converted my input string from the Execute command activity stage to Integer in the job activity.

Thanks for the valuable time spent to answer the question

Hi Tried passing the value from the execute command activity stage directly to the job activity which has an integer job parameter. it throws me below error , which i could infer that job activity is not doing a default conversion ... Test_suurogate_seq..JobControl (@Job_Activity_9): Controller prob...

Hi , I am not getting any conversion errors . I am stuck very before that as i am not aware how i coud use one such. I tried to search some routine/transform to convert in the expression editor but I am not getting any integer conversion routines/treansforms in the expression edition . I am expectin...

Hi , I am not getting any conversion errors . I am stuck very before that as i am not aware how i coud use one such. I tried to search some routine/transform to convert in the expression editor but I am not getting any integer conversion routines/treansforms in the expression edition . I am expectin...

Hi I am building a sequence that is used for dimensional load. It contains an Execute command stage with the command Cat and parameters as filepath/file_name.txt. This would give me the maximum surrogate key for a dimension table. I have to Pass this to another job as in integer, so that the downstr...

Hi I am having a stream with a design like Copy -----> Aggregate ---->seq file. The data flow in the job is not enormous and hence i have made all the stages to work sequential. I am processing just two columns in the above stream. Copy: ==== 1) Retrieve key and measure calculation column from upstr...

Sorry for the confusion. The problem was i was not able to get delete records out of the change capture..In the sense i was getting a null value for all th columns in the record which was designated as a delete record. But on analysis i found that its not that change capture stage is causing problem...

Hi, I am generating datasets for loading a type 2 dimension table. The requirement is to capture the delete records from the change capture stage and using the delete record's key i have to update the dimensio table with an end date. When i use the change capture stage, i was able to retrieve the re...

Hi , I remember there was a post that detailed all the error message and their description for the DSjob command, I am desperately looking for that. I tried all the possible means of searcing through this forum for the complete list of the errors and their description for DSjob command but the resul...

Hi , I am converting a sequential file created in .txt format using a server job to a parallel dataset. A before job subroutine would be used to convert a file with decimal and text columns to an all text column file which is used as an source for the job The design is something like Seq file_0 ----...

Hi , I am using a sequential file from a server job as a source to my parallel job. There were data type inconsistancies in parallel while using the Sequential file, so i planned to convert the data in a sequential file to a complete text format using the sed commands( Remove all the double quotes f...

Hi , I have two keys from the source and three keys in my Look up oracle table. Key1 in the source table should be equal to Key 1 in the lookup table ...This is achievable just by mapping the two columns in the transformer and would be automatically passed to the Where clause of the Oracle stage. Bu...