DSXchange

This is a vertical pivot requirement. Ostensibly the Pivot Enterprise stage in version 8.1 can perform vertical pivots, but I don't believe that's the case. Certainly it can in version 8.5. (I don' ... Hey Thanks Alot for taking time in thinking about this scenario. I actually resolved it using sor...

Also


The Values 678 IS FOR CD2 , AND 901 is for CD3 .. as if the CD1,CD2,CD3 values are in diag pattern..

[moderator - fixed it for you, code tags preserve whitespace]

chulett wrote:You posted in the Server forum and marked the Job Type as Parallel - which is correct?

This is in parallel version... Sorry abt that..

Hi, I have a scenario with removing duplicates which i am trying to resolve Input : CGIS_ID LINENO CD1 CD2 CD3 10001 1 345 10001 1 678 10001 1 901 10001 2 450 10003 786 Note : (Duplicate keys are CGIS_ID and LineNO) Output ld be CGIS_ID LINENO CD1 CD2 CD3 10001 1 345 678 901 10001 2 450 786 Each CGI...

I have a dataset file which is being loaded in a table after a number of transformer stages. But, in the table, we are getting some junk values (mostly ???????) in the description column. I need to clean the data and load that into the table. That is, if the values are null, or may be some junk, the...

it worked.....thank you

Job executes with no errors when I change the data type of "Date" field from "Varchar" to "Date" using the specification "date_from_ustring" in the modify stage but when I change the data type of "Date" field from "Date" to "Varchar&qu...

Hi All, I have problem performing a simple job using modify stage source was a text file with 5 fields. to that i added a date column in the end All fields are pipe delimited. I gave datatype as 'varchar' for the five fields and 'Date' to the date field I droped two columns(keeping the date column) ...

I just want to know how to connect to datastage in unix environment. I wud like to know any , all commands that we use to login.
Thanks