Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6443 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by active and passive transformation?
What are the new features of informatica 9.x developer?
How to partition the Session?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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. ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the components of Informatica? And what is the purpose of each?
Write the advantages of partitioning a session?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
how to load rows into fact table in data warehouse
Explain load alternative records / rows into multiple targets - informatica
What is a snowflake schema?
How do you load only null records into target?
What is the difference between writing a joiner query in ANSI style and THETA style?
