DSXchange

Which one is the key column in XML Output stage under Input->Columns tab?

As per my understanding of Hash partitioning same key values will be partitioned into same processing node. How Hash partitioning works with/without key values Sorted? Why Sorting is mandatory when the partitioning method is Hash? What happens if the records are Hash partitioned but not Sorted in st...

what is your column definition for this field?

Hi,

There are 2 options to specify sort in Change Capture stage

1. Sort Order under Stage->Properties->Change Keys->Key
2. Hash partitioning and sorting on the input links

What is the difference between these 2 sorts and do we need to use both of these sort methods in Change Capture stage?

Hi, An input file has column defintion as Id, StatusCode1, StatusCode2,...StatusCode82 and a table has column definition as StatusCode. If any one of the StatusCode (StatusCode1 to StatusCode82) from input file matches with table's StatusCode then that record has to go to one link otherwise it has t...

Thanks ArndW and Bhasds for your inputs, I have used the logic provided by ArndW and it works fine.

Hi, My column defintion is as below. 1. Status_1 char(2) 2. Date_1 char(8 ) 3. Status_2 char(2) 4. Date_2 char(8 ) . . . 247. Status_124 char(2) 248. Date_124 char(8 ) Condition to check: If any of these 124 status field's value is 'AB' or 'CD' or 'EF' then I need to get the corresponding Date field...

Hi, I have a date field in my input and if the difference between this date field and current date is less than 15 months, i need to process the records. For example current date is 8/13/2012 so i can process the records where input date field is greter than 5/13/2011. Is there a funtion to acheive ...

Job design is CFF stage -> 11 Dataset stages

The records are getting extracted and written into datasets but the link count is showing as 0 for all the 11 datasets but I am able to view the data in the datasets.

Any idea why the link count is showing as 0?

There are around 120 record types in the file and I need to extract only 11 out of 120, so it deosn't seem to be flexible to define all the 120 record types. Is there any other way around?

Is there a way to remove the below warning message?

cff_1,0: Tag value: 27 does not match any tagcase for tagged field "cff_1_record_type"

Reason for warning: The record type 27 exists in the input data but we don't need in output, so it is not mapped to output.

Thanks ArndW.. I have one more question. There are some fields defined as DECIMAL in CFF stage and when I try to view the data or run the job I am getting below warning message. Field "RECORD_LENGTH" has import error and no default value; data: {0 8 4}, at offset: 0 where RECORD_LENGTH is ...

Hi, Thank you, after adding quote it worked fine when each record type is in separate rows. Example: <Row1> 01 123456789Joe Test 1 <Row2> 02 Account1 100.00 2 <Row3> 03 News Anchor 52000.00 3 When there are more than one record type in a row then it is reading only first record type and not the othe...

I am trying with a sample job and below is my schema. record {record_delim='\n', delim=none, quote=none, binary, ascii, native_endian, charset='ISO-8859-1'} ( complex_flat_file_1_record_id:string[2] {position=0,link,}; complex_flat_file_1_record_type:tagged {reference=complex_flat_file_1_record_id,p...