Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Large string attribute type gets truncated during ETL

Hi All,
           I have a large string attribute. Entered data for it in 1 workitem. But when i run the ETL Job and see the backend insight database, only half of its content is retrieved. Why is it so? How to resolve this?

Thanks.

0 votes



One answer

Permanent link
in the XML Data Configuration tool, when you create a data mapping table, and specify the Table Column name, XPath, SQL Type, Length, etc. please make sure the Length is set to the number you are expecting.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 11 '12, 12:37 a.m.

Question was seen: 4,579 times

Last updated: Nov 06 '12, 4:58 a.m.

Confirmation Cancel Confirm