DSXchange

Open the properties of XML output stage. Go to the 'Transformation Setting' tab. There are two check boxes for * Replace NULLs with empty values * Replace empty values with NULLs I guess in your case you need to check the second check box. If this didn't work uncheck this and check the first one. Ei...

Open the properties of XML output stage. Go to the 'Transformation Setting' tab. There are two check boxes for * Replace NULLs with empty values * Replace empty values with NULLs I guess in your case you need to check the first check box. If this didn't work uncheck this and check the second one. Ei...

Pivot works otherway round, it convert single row in to multiple rows.

You can use a Pivot to make columns into Rows, based on your requirements.
-U

Hi, You can acheive this by using a server Job. Read your first line in source file and store data in a hash file like follows; Name : HSH_FILE Fields : NAME,REF,VALUE KEY : NAME Once you process the first line hash table should look like below, you can use lookup to populate REF column. NAME REF VA...

Do you have Basic Transfoemer Stage in Version 8. If so, you can try this. To catch rows which caused a write failures on an output link, set the Constraint field to linkname.REJECTEDCODE. The value of linkname.REJECTEDCODE will be non-zero if the row was rejected due to a write failure or 0 (DSE.NO...

There are two ways to resolve this issue;

1. Change the length of your input data from 12 to 10

OR

2. Change the specification as follows;
OutCol1:decimal[12]=decimal_from_string(InCol1)
Make sure output column tab also has the same metadata decimal(12,0) for OutCol1.

Can you provide the following details.
1. What is the datatype of Input tab of Modify Stage (LoanNumber)
2. What is the datatype of Output tab of Modify Stage (LoanNumber)
3. What is the Specification for this column ?

This may be due to different types of Metadata defined for LoanNumber column. Make sure that both input/output has same type of metadata. In this case specially precision should be same for both input/output.

This may be due to different types of Metadata defined for LoanNumber column. Make sure that both input/output has same type of metadata. In this case specially precision should be same for both input/output.

New specifications(columns) won't appear automatically. You need to type the metadata manually.

I can't understand that why do you use a transformer in between DataSet and Modify Stage. Modify stage is a light weight Transformer. Can you drop the Transformer stage and link the output of DataSet to Modify Stage. This may resolve your problem.

Use a Pivot stage and define the OUTPUT of Pivot as follows
1. PKey
2.CustNum
3. Address
4. Telephone
5. Zip
6. Total_Amt
7.Total_Rebate

Use the following derivations;
Address : Add_1,Add_2, Add_3
Telephone : Tel_1 , Tel_2, Tel_3
Zip : Zip_1,Zip_2, Zip_3

e89448

Hi Does any one knows about the storage limitation about a DataSet. I've designed a job for a Dataset with 398 columns and 1,000,000 source records. When I executed the job I can see only 521327 records stored in DataSet with 4,270,718,976 bytes. So, What happened to rest of my source records ? Is t...