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
- 5684 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 are factless facts? And in which scenario will you use such kinds of fact tables.
what is the difference between mapplet & stored procedure?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Explain direct and indirect flat file loading (source file type) - informatica
what is the size of u r source(like file or table)?
what is junk dimension
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
How to identify this row for insert and this row for update in dynamic lookup cache
Teradata 
