DSXchange

Hi, Don't know if I understood your problem well but here is something I often use on my project : Seems that you're able to select the max key in your Dimension. Seems that you're able to put a Surrogate Key Generator to generate a unique sequence (1->X) on each of your Source line. Perform the Loo...

Okay, Just solved the problem. It seems that PX version 7.1, while using the Join Stage, automatically sort your input data. I'm used to partition my data before the Join stage and check the Sort box as well... that's why I get the Warning !! All I had to do to solve it, was to uncheck the sort box....

Hi, You have to enter the StringToDate Function which format your source string is. In your Case, use : StringToDate(DSLink8.First_Due_Date,"%dd%mm%yyyy %hh%nn%ss") Maybe you'll have to manipulate your source field so that it can fit the format. Also, beware of NULLABLE field while applyin...

Hi All, I just had a few errors with a corrupt Dataset and it seems to be because of a partitionning "error" while loading a Dataset. Here is the deal : I have a dataset that is loaded in different jobs, before being used to create a log file and then purged. The job where I create the Fla...

OK... I thought I had used PX 2 years without understanding anything... Saved !! :wink: So let's get back to the subject : :twisted: Far earlier, Rich said that the Error "Unbalanced Input From partition 0..." is due to a Hash partitioning made Twice. Is it the real problem then ? :?: Acco...

Woow... so that mean that you can't use the same Dataset if you have to perform Join/Lookup/Merge... operations on different key values ? I mean, each Time I had to do that, I used to "repartition" my "Reference" Dataset by hashing it on another key depending on the data I wanted...

Can this error happen even if you're using HASH Partitioning but twice but on two different Key values ?? Hi Vignesh, This is due to wrong partitioning. You have done the HASH partitioning twice. If you have done HASH partitioning once use the SAME partitioning for the remaining stages until you do ...

Hi, So, if I understand well, you've got a condition (linkname.no >= "105") for you reject link and none for the "clean" one ? If you don't have any condition on a link, every input data will be processed in this link. Maybe you should define a condition for the "Clean"...

By the way... Thanks a lot for the Help !! Ganive - excellent solution; somehow I got this thread mixed up with the other one currently running with a similar subject content and recalled that the $APT_STRING_PADCHAR didn't work so I didn't even consider that approach. You've got the best solution f...

Yes, I think it would have been the good way to realize our jobs. A little bit more "difficult" to do now as we are not far from the end. I've made a few test and it seems that putting the APT_STRING _PADCHAR option on the job where I put my TRIM value in the CHAR field is another way to s...

I tried this already... Padchar options, Fill char... Unfortunately it doesn't work... it seems that having the TRIM operation put in a CHAR string has already filled my column with "Null" value :s ganive, if you go to your output stage, choose your column and right-click to enter the &quo...

Hi All, I thought I had something very simple to do... but it's not !! Here's the deal : I have a dataset, containing string defined as CHAR. Datas in these string have been TRIMMED. I want to generate a flat file, fixed length, based on the structure of this Dataset... so I have to add 0,1 or more ...

Okay, understood. I think the File Set Stage doesn't fit my needs. I thought it was something I could Use to create a group of Flat File in a particular directory whereas it seems to be similar to Dataset stage (a control file pointing on one or more data files). Seems I have 2 Ways to solve my prob...

What's the syntax used in a File Set configuration file ??
I only know it the configuration file should end in .fs :s

ray.wurlod wrote:You create a File Set by writing to a File Set stage.

Specify eight-way partitioning in a configuration file.

Run job.

Done.

OK, Thanks a lot !! I'm going to use filler in order to solve the problem. Not so much fun when you have to select "unfollowing" data in a record (you have to define a filler between each data), but if it's the only way to work. Just define a third column that contains the rest of the data...