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 |
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is shared Cache. when we will use shared Cache?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
whatis the default data driven operation in informatica
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
How the facts will be loaded? explain
What is up date strategy and what are the options for update strategy?
where to store informatica rejected data?
How to implement security measures using repository manager?
COM components can be used in Informatica