DSXchange

Hi I have table ABC and need to join on DEF. relation ship on ABC and DEF is one to many. if my key column for join is COLUMN_TEST. suppose COLUMN_TEST in ABC table has a value 123 and same COLUMN_TEST in DEF may have multiple records with value 123. Can some please let me know how to acomplish this...

I am having Date as "MMDDYY" format.
I have to convert this one as "YYMMDD" and also concatenate '20' to year.
Please send me the solution for this.

Hi

max_date is VARCHAR in PARAM_TABLE.


Thanks
Suri

Hi All, Thanks a lot for all your suggestions. I'm using the multiple instance job to load multiple dimensions. Now I need to extract data from source using parameter table to get the MAX_DATE and MAX_SEQ_NO. Extract SQL looks like below: SELECT * FROM #$SCHEMA_NAME#.#SrcTblNm# WHERE ATTRIBUTE_NAME ...

In ideal world, it would be better to use a lookup stage in such scenario.
But based on how your database/table is loaded, you can also code it in the SQL statement.

However do not use a transformer as it has no specific advantage over a lookup.

thank you every one for the reply, The actual issue is, I requested IBM for a patch since the CAST when used with Union-all is removing the precision. IBM has replied it is more related to do with the UNION operation which is removing the precision but not the CAST field. Could you please run the fo...

Column_A is defined as Decimal(31,11) in the Oracle stage(column definition) In the SQL query, I have SELECT CAST( Column_A as NUMBER(31,11)) Column_A, Column_B From Table_X Union All SELECT CAST( Column_A as NUMBER(31,11)) Column_A, Column_B From Table_X When I run the job by putting this query in ...

Hi All, I have a dataset which looks like the following Name Value A 1 B 2 A 45 A 23 C 17 B 12 C 32 A 21 C 65 I need to load A,B and C table. This three table has the same structure. Please find the A table structure with the data. Sno Value create_dt end_dt current_flag 1 1 1/31/2005 1/1/9999 Y 2 4...

Hi,

I'm sorting the data in ascending order for natural keys and decending order for one of the timestamp column.

same order I'm maintaining in the remove duplicate stage to get the latest record.

Thanks
Suresh

Hi All, I need to create 100 dimensions for one of our data mart, source data is SAP and each dimension represents one attribute. All the 100 dimensions have the same source (one table) and have the same target structure (100 attribute dimension). I thought of creating a multiple instance job and pa...

Hi Purush, I had similer kind of issue, the following script helped me out to remove the carriage return. if [ $UNAME = "SunOS" ] then dos2unix ${SRC_PATHNM}/$FILENM ${INT_PATHNM} $FILENM.dos2unix grep -v "^$" ${INT_PATHNM}/$FILENM.dos2unix > ${INT_PATHNM}/$FILENM rm -f ${INT_PAT...

Hi, I'm reading a sequential file and passing it to transformer to do hash partition. data from trnsformer is passed to Sort stage where I'm doing Sorting on natural key in ascending and timestamp in descending to get the latest record at the top then it is passed to remove duplicate stage to retain...

Dsguru thanks for your reply.Database is sybase.Can i call these routine using excecute command activity and parse command output values to the job parameters like reading from a parameter file?Could you plz share some sample code or link i can refer too?Thanks for your time.

Hi guru's,

I have to pass set of parameter values to a job sequence from tables.I acheived it through writing to a file and the read it as parameter file.Is there any other way to perform this?Thanks.

sorry ray.It is a user defined routine.Could you please suggest one method to read a parameter file in PX.thanks for your time.