DSXchange

For splitting one record into multiple record, the easiest way I can think of will be put a copy stage after reading the data, from copy stage drag the fields you want in the first record link and drag the fields for the second record link and so on for N number of records links. After this for merg...

Hi All, I have a small problem related to Datasets. My jobs which has DataSet as the source or target doesn't run any better then the one having the sequential file. Is it something related to my server or the configuration file? My server has 4CPUs and 16GB and some 200 GB of HDD(RED 5) memory. My ...

Delete the property "QUOTE" completely, and then try it out.

Please let us know what was the resolution for the issue?

You can check for two more things:

* Delete the property "Delimiter" completely.
* There are spaces at the end of each record or not so that the total character count in a record becomes 91.

In that situation the test data that u have posted is wrong. As there are spaces for the numeric columns(that to in between two numbers of same field).

I agree this must be due to a invalid date, verify the date before inserting. Which genrally should be followed to avoid any issues in live environment.
Check the format of date u are inserting the data in?

Do you actually have spaces in the data or is just for the representation purpose you have put the sapces?
Please verify the data as per the metadata you have provided.

Is there any field size you have defined in the target sequential file?
If No, then it takes the default size of the varchar as 1024.

can you please post the details how the problem resolved.

can you please give a tentative structure of the job and what is the warning which is comming in the director.

Is there anykind of warning/error message comming in the director?

Why don't u use the DB2 enterprise stage.

I didn't got the exact meaning? Can you be more precise and descriptive!

The only way a the sparse lookup can be performed is that you connect the DB2 stage dirctly to the lookup(without any other stage in between DB2 and lookup).