DSXchange

Is it an upgradation from an existion installation.
Are you able to access from other clients like manager or director or designer.
Have you tried uninstalling and reintalling the client in the system.
Any other issue faced while working in the project in designer.

As long as the partition is based on the all the key mentioned in the PIVOT the functionality will not be affected in parallel operation.

Let make ETL tool to work more.

Is it only to a particular project or to all existing project?

Iam wondering with the comment given in README.txt You can use the same code as above directly in a derivation if you wish, but your job will run slower due to the need to make the function call each time it is used in a row instead of once at the start of the stage.... .....if for some reason it ha...

It can be realised using the transformer stage variables.
Sort based on TBNAME and COLNO. Check for the previous and current row uniqness on the column TBNAME. Based on the same group concatinate the Column name into a single field.
BTW that was actually a Vertical PIVOT.

That is... No of input rows need not to be same as no of output row for a link in transformer.

Iam too not sure about the change in Array size option in DB2 stage and the reject in a transformer prior to that stage. Have you tried the reject link directly from the DB2 stage?

Are you speaking about PIVOT in DB?

To facilitate the porcess of collecting the table defenitions to a centelized repository, MetaBrokers can be used.

What if you try SAME partition on both copy and DB2 stage?

Assign the parameter name as COB_DT and Default value as $COB_DT so that the value is retrived dymaically. and Use the parameter as COB_DT in transformer.

What is the value of DB2INSTANCE in dsenv?

Also the metadata reconcilation takes place.

Hi,
How many nodes availble in server?
How many are configured? Is it running in sequential mode?
What is the partition mentiond in copy and target db2.