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 3438Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 7663How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 9421When 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 16260Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 15799Post New IBM Informatica Interview Questions
What is static class in C#?
Explain servlet life cycle?
What is private void in c#?
Why does the radius of armature is less than the radius of pole shoe?
Explain how is a property designated as read-only?
What is the advantage of spring mvc?
How do you run a query?
What are joins?
How can we implement spa with angular?
What is bundle js in angular?
How to recompile stored procedure at run time?
How can we force the database to use the user specified rollback segment?
Can you tell something about the data ware-house hierarchy?
Hi, If anyone has base SAS certification dumps, please share.
What are the performance testing tools?