IF Sorce table contains CLOB as its one data type then i
get error at the target table. How can this be resolve?
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 |
Target is zero file and how can you send the email?
HOW TO YOU LOAD TIME DIMENSION
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
what is casual dimension?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What are the out put files that the informatica server creates during the session running?
Can we make worklet inside worklet?
How you can differentiate between connected lookup and unconnected lookup?
What can we do to improve the performance of informatica aggregator transformation?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What are the mapping paramaters and mapping variables?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,