IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?
- 2 Answers
- 5982 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shaik
In target table Change the data type as varchar2()
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sandeep
When a CLOB datatype is pulled in Informatica,that port in Source Qualifier should be converted to String datatype and propagate the same till the target.
It works then.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
What is a sorter transformation?
Enlist some properties of sessions.
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
can every transfomation reusable?how?
Define maping and sessions?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Teradata 
