DSXchange

The Actual data is in the format "0001-01-01"

Its a date but we have it as char in the source. When we use it as char in server it works fine.

The Actual data is in the format "0001-01-01"

Its a date but we have it as char in the source. When we use it as char in server it works fine.

I am having trouble viewing the data from a sequential file. Here is the error ##I TFCN 000001 09:49:58(000) <main_program> DataStage XE Parallel Extender V7.0.0 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc. All Rights Reserved ##I TOSH 000002 09:49:58(001) <main_program> orchgeneral: loa...

ray.wurlod wrote:It's "hashed" file, not hash file.

Oops ! , Bad Work Lingo ...

I need to use a hashfile which is a output from a serverjob as a shared container in parallel. My questions is 1) how can I create a container with only the hashfile ? 2) can I write the hashfile to a seq file and use it as a lookup file set ?, do I need to take any precautions when I am writing has...

I am giving the columns which I changed as "value columns". Its works now ... and it takes the changes I made as EDIT.

Sorry.... I confused u Kumar, As you said, when there are new rows in the AFTER data it shows them as insert. But if the values in the existing rows are changed , how can I get those rows out ? ex: If this is the BEFORE data 111 aaa bbb 222 aaa bbb 333 yyy zzz And this is the AFTER data 111 aaa bbb ...

I tried it and when I select TRUE for the DROP OUTPUT FOR COPY option , It gives me the correct result with the CODES.

But I want the job to output the rows which are not present in the BEFORE data set and are present in the AFTER data set. ie: the updated rows.

Is there a option to do that ?

I think I'v confused you guys. The job I have to do is compare 2 sequential files (1 from DEV and 1 from PROD) and see if they are the same. If they are not the same and the records have different data then I have to write the data which is different into another Seq file. I am trying to use Change ...

I have about 60 columns , MGMT_NO is the key.

I have manually hardcoded the city name and zipext . So now when I select the option "Drop Output for Copy" to be "True" the job should write out the rows which have been hardcoded by me right ?

Done, Works now ... 1 more question As of now I am using "change code" to check if the data has been changed. I wanna know how to write the changed data to a file. I have created test data to check if what I am doin is right, I made changes to 3 columns in one of the source data by hardcod...

Error: Input 'cc_PromoMaster.l_Previous' Sort requires a key column
Error: Input 'cc_PromoMaster.l_Current' Partitioner requires a key column
Error: Input 'cc_PromoMaster.l_Current' Sort requires a key column


Whats does this mean ?... I have specified a key

chulett wrote:So why is this marked as a 'Server' question?

oops my bad ..

Do you mean the METADATA ? .. I havnt given the name of the files anywhere in the CC stage. Am i required to ?

The link ordering tab shows which file is input and output.

The 2 sources I am using are sequential files with diferrent names, they have the same data and metadata. I am just trying to test the stage as I'v never used it before. There is 1 key for the file and I am doing an Internal ascending sort. change mode = Explicit keys, All values Drop Output for Cop...