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
- 6577 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 |
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can a transformation be made reusable?
how may sources can be used in a mapping at a time?(limit)
what are the difference between Informatica 7.1 and 8.1?
Under which circumstances, informatica server creates reject files?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Why update strategy and union transformations are active? Explain with examples.
What are the out put files that the informatica server creates during the session running?
What are the joiner caches?
What are teh different tasks that can be created in workflow manager?
What is data merging, data cleansing and sampling?
Teradata 
