Interested to Buy Any Domain ? << Click Here >> for more details...
Want to know about Training Centres for Informatica, Cognos
and ETL Softwares in Mumbai, India.
- 27 Answers
- 47564 Views
- I also Faced
- E-Mail Answers
Answer Posted / anand
Study at WWW.geoinsyssoft.com
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to load rows into fact table in data warehouse
What is data caches/ index caches?
How to partition the Session?
What is the use of code page?
What is a code page?
What is the commit type if you have a transaction control transformation in the mapping?
wat are deployement groups in informatica, how it will be used for developers
Explain informatica architecture - version 8 / 9
What are the types of presistent cache in look up tr.
What is the way to execute pl/sql script using informatica mapping?
How do you migrate data from one environment to another?
What is meant by target load plan?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
