DSXchange

ArndW wrote:If you turn on APT_DUMP_SCORE and look at the generated scores do you see any repartitioning being performed? ...

Havent tried this. Will look into this. But do you thing that this will work?

Hi, I have 5 datasets which are created in some jobs, all these datasets are hash partioned on one key column as A. There is one job where I join all these datasets by using one join. out of these 5 datasets , I perform a left outer on one dataset. Rest 4 are right outer. The key that is used for jo...

Hi, I have a requirement where I need to convert hexadecimal value coming from source to Decimal in the target. Suppose if the source value is X'0055', than the target should be 85. Can some one suggest? Should we do it by calculations, like dividing by 16 and than considering the remainder and quot...

Do an internet search for "SIGSEGV" (segmentation violation) then tell us about what memory-hungry operators are mentioned in your score. ... Well, I dont understand what you are asking for, but throgh google serch i found that this problem is because of the memory is unallocated or unmap...

Hi, We have a job, where we are reading the data from complex flat file, doing some transformations in transformer, doing aggrgation and writing into the dataset. However the job aborts and give error as "operator terminated abonormally received signal SIGSEGV". This error we get after tra...

Hi we have the following requirement, sort code accnt no A B C OccuNo 11 22 5 6 8 1 11 22 8 9 0 2 33 44 6 3 2 1 Output should be like 11 22 5 6 8 8 9 0 33 44 6 3 2 '' '' '' Can some one helpas how to implemnet it without running the transformer in sequentail. Here the most important part is that the...

Again, what exactly are you doing? You "simply put zero" in what kind of output column - based on your PIC X(3) notation, are you actually putting zeroes in a Char(3) field and expecting it to work? Try making sure your APT_STRING_PADCHAR environment variable is set to "0x00" an...

From what little I recall, "low values" would indeed be "hex zeroes" so you may not actually be setting this up correctly and thus ending up with a decimal zero instead. Can you explain exactly how you are doing this? Field data type, derivation, etc etc. Yes, You are correct.Lo...

chulett wrote:So... what IS the case?

Hex of zero is nothing but zero. So when we see the output data in mainframes, it is seen as zero which is wrong!! Not sure what actually low values means . This has been raised as a defect!!

Hi, We are creating output files where we need to map low values for certain columns in data stage. This file dta will be seen in mainframes where we should see low values for certain columns. I assumed that low values is nothing but HEx(0) that is hex of zero. But it is not the case. Can someone su...

Hi well I think this comes down to two situations: 1) if the migartion date is a Monday or Tuesday then you will look for a difference of 3 2) if the migration date is Wednesday, Thursday or Friday then use a difference of 5 So you just have to determine the day (name or number) i.e. with oconv reg...

ray.wurlod wrote:What evidence do you have that Oracle is involved?

Funnily enough, not everyone in the world uses Oracle.

Correct!! This is complete file system and there si no data base involved here.

Hi well I think this comes down to two situations: 1) if the migartion date is a Monday or Tuesday then you will look for a difference of 3 2) if the migration date is Wednesday, Thursday or Friday then use a difference of 5 So you just have to determine the day (name or number) i.e. with oconv reg...

ArndW wrote:The DaysSinceFromDate() function gives you the difference in days between your two dates. The WeekdayFromDate() function returns the weekday number. Then use the days difference and day-of-week to co ...

I did not get your Full reply.

Hi, I have 2 dates. One is migration date which will alwyas have a fixed value.Migration date is passed as job parameter. The other date is coming from source and will have different values. I need to compare 2 dates and if the difference between the 2 dates in greater than 3 working days, I need t...