DSXchange

Hi Pravin

To set the property to reject , you have go to the constraints and set lookup to drop/continue/fail/reject . You have set it to fail and thats y the job ends with a failure

Hi Folks I have a extract job where i use file pattern to merge files into a singular DataSet. The file names are like Data-1.csv Data-2.csv I use a file pattern Data-*.csv to merge it , is it possible to distinguish what data came from which file ..or i'd be ending up using 2 extract jobs

I am having two input files as - input 1 input 2 A A B B C C F D E I want output as : A with data from Input 1 and Input 2 B with data from Input 1 and Input 2 C with data from Input 1 and Input 2 D E F with data from Input 1 Or if is not possible then create two outputs Output 1 - Matched records ...

Thanks for your replies The following was the mistake i had made The inputs were hash partitioned and sorted , and i was giving the partition to be Auto in the stage Thanks to you too Vincent , i need data from only one file where keys were same so the "after" link was that , if uniques we...

Hello Folks I have a requirement to merge 2 files , with precedence to the first file. I have used a change capture to do this . File1 is copied and one is put to output and other link is put to change capture, file2 is directly put to change capture . After ChangeCapture data is merged with file1 d...

Hi Folks

How can we specify UNIX EOF as record Delimiter while reading a Sequential file

Hello Folks In one of the jobs we have , we extract a Year from Database and compare that with all the rows (each row has a year column) . Right now i use a CG , using Dummy keys i lookup the input from DB and append the year to all columns . Then it is taken to a Transformer to do a comparison . Is...

Hello Folks Tried to execute the "dsrecords" utility , i get the following error . Is there some Env variables that need to be set additionally for Execution Could not load program ./dsrecords: Dependent module liborchaix3.a(libtemp.o) could not be loaded. Could not load module liborchaix3...

Hi folks

I have a requirement where i have to do check if the Date supplied in the input is less than x Days from the current date . We do have a Transformer utility (DaysSinceDate) , is the same possible from Non-Transformer stages ?

Split file1 using a Copy stage into two streams. The first stream, all rows from file 1, go to output. The second stream is compared with data from file 2 using the stage of your choice (Change Capt ... I tried doing the same , not on actual job but as a POC . 1|AA|100 1|AA|25 2|BB|101 2|BB|26 3|DD...

Hello folks I have 2 files , each row is defined by 3 Key Columns . Apart from that i have 2 Non Key columns as well . Some keys are common on both the files , preference to the output then goes to data from first file . If the records are unique on either files, they qualify for output automaticall...

Hi, Please how will I solve such a scenario? I have a column A: 23434 45235 AB234 13443 12444 AB324 13443 AB324 12334 I want such an output 23434 1 45235 2 AB234 3 13443 3 AB324 4 13443 4 AB324 5 12334 5 Basically if column A[1,2]="AB" the number remains the same. I defined sth like this ...

DSguru2B wrote:Sure you can. You need to write a routine that checks for file existence and returns an appropriate return value which you can then check inside the transformer and proceed. I wrote a simple one months back. Search for it here.

Any keywords that i have to look for search ..

Hey Folks

Is it possible to find if a file exists from a transformer stage ..can we have a constraint defined based on the existence and non existence of a file

I am trying to count the of days between the Transaction date and the date posted. What is the correct syntax for the modify stage. NumofDays = DaysSinceFromDate (DatePosted,TransDate) Thanks. if you are looking for the transformer function , here is a sample of how to use that DaysSinceFromDate(In...