DSXchange

Hi , In my DDL , I've got 4 columns as the primary key of the columns and for all the join stage I'm using the "Hash" partitioning , is this the right approach or I should go for Auto. I've got the impression that when we say "Auto" datastage uses the "round robin" or &...

Hi , As per suggession I did set the properties and initially I was collectinng the result into the dataset but now instead of that I'm collecting it in the .csv and the problem got solved. As I was looking into .ds I got impression that it's generating keys like 1,3,5 etc... Thanks Hi, In case you ...

Hi, I'm using the surrogate key generator stage to create the keys. I'm using the 2 node config file in the development environment. I also set the partitioning on the i/p tab to "round robin" to avoid the key hole problem. But still I'vegot the same problem... the o/p from the stage is 1,...

Thanks...it worked

Bilwakunj

vbeeram wrote:Hi,

Yours source column must be String type i.e varchar
You also specify the I/P Source format.

Syntax: StringToDate(Column,"source column format ")

In your case
ex:StringToDate(DateLiknk.Date1,"%yyyy%mm%dd")

This will work.

Rgds
Thiru

Hi, I've 2 datasets. The left one has got 12 columns and the righht one has got 5 columns. out of 5 , 4 are the key columns which are common in left as well as right, their names are also same in both. I'm trying to do the left outer join with data sets by joining on the key columns and in the deriv...

oops...sorryy.. Thanks Ray. How about you tell us how you're trying to do it, then we might be able to spot a problem? It's really difficult to tell you if you're making a mistake if we can't see what you're doing! And you might have better luck if you posted on the Parallel forum rather than here o...

Hi , I have a col of char '8' and another of char '10'. Using stringToDate() function I'm trying to convert these columns to a date, with the default date format. But it's not working. The job is getting aborted. Well I'm putting following in the derivation StringToDate(inData.Date1) -- and trying t...

Hi ,
I have a col of char '8' and another of char '10'. Using stringToDate() function I'm trying to convert these columns to a date, with the default date format. But it's not working. The job is getting aborted.
Can anybody plz tell me , what mistake I'm doing?

Thanks.

Thanks Ray. I've a situation as described below. In fact I had posted this on the forum but here is the full version of the requirement. So I'm posting it again. Col A - char (8) Col B - char (2) Col A_Date char(8) Col D_Date char(8) col C char(3) Now my job demands, if Col A = Col B = Col C, mark t...

Hi, I want to know how is the order of execution in PX. Say my PX job has processed 1 row. Now 2nd row is on the verge of beginning. Does PX first flush off all the information of the previous row before actually start the processing of new row OR sequentially when PX approaches the column derivatio...

Hi, I have two datasets, driver and reference. Both of them have same metadata and same column names. The values for the primary key columns may be different or same also for the other columns values may be same or different. I want to capture all the cases so I'm going for full outer join (as volum...

Thanks guys for your valuable help!!! But I couldn't get very clearly this solution.. can you please explain with some minimal code please.. One other solution: Use: [Sort] -> [Transformer] Sort the key in order of case (ascending), and date (ascending). Use Transformer's Stage Variable to retain th...

Hi, I've a data like this: case 11 Date1=11/7/2004 Date2 = 11/19/2004 case 11 Date1=11/17/2004 Date2 = 11/29/2004 case 11 Date1=12/7/2004 Date2 = 10/19/2004 case 22 Date1=02/7/2003 Date2 = 10/19/2004 This is how the data is present in the dataset, Now I need to compare Date1 of each record with the ...

Hi, I've a following situation. I'm supposed to do a look up on 1 dataset (primary i/p) and a oracle table (reference link) based on 5 columns. 1. A 2. B 3. Date1 4. Date2 5. C Now the criteria is if there is a match found on colum A, B and C, it meets the initial criteria. And from the output of th...

Hi,
I've a job where I need to find out the specified date is in between the start date and end date or not.
I've gone through the date functions of PX but i couldn't find any.
Can anybody give me any idea how to do this in PX?

Thanks,
bilwakunj