Jump to content

Informatica - Clob Datatype Issue


Recommended Posts

Posted

[quote name='jaffanajeffada' timestamp='1365085372' post='1303541129']


this is what needs to be done Masthan bhai

Check the max length of data for that CLOB column in database... if you get 5000 as the length, In Source and target Object set it to CLOB 15000 or more(atleast 3 times)

from Source qualifier onwards, set it to TEXT 15000
[/quote]

terriffic jaffa bhai..

Posted

[quote name='jaffanajeffada' timestamp='1365085372' post='1303541129']


this is what needs to be done Masthan bhai

Check the max length of data for that CLOB column in database... if you get 5000 as the length, In Source and target Object set it to CLOB 15000 or more(atleast 3 times)

from Source qualifier onwards, set it to TEXT 15000
[/quote]


Perfect...Thank you.!

  • 8 months later...
Posted

ivvala malli use ayyindhi ee thread, for the same problem :)

×
×
  • Create New...