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
1 4170Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 9007How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 11136When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
3 17545Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 19099Post New IBM Informatica Interview Questions
Describe your approach to managing difficult airways and the steps you take to secure a patient's airway.
What is nest?
What are services in javascript?
What is the difference between margin and padding in android layout?
what is outbound email integration?
What is Perceptron in Machine Learning?
Can a variable be both static and volatile in c?
What are the config properties of presto?
Is java 9 released?
What is the difference between the Internet of Things (IoT) and the Sensor Business?
How to install a new module in drupal?
What is property schema?
What is CamelContext in camel?
What are server-side comments in ASP.NET?
What are the uses of time standards?