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 4164Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 8987How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 11122When 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 17530Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 19035Post New IBM Informatica Interview Questions
Mention the different types of cursor?
What are the capabilities of selenium ide?
Clarify what information architecture?
does anyone have qtp11.0 license key.Please sendit to my mail id-rrvv2011@gmail.com...Thanks
What is the generic class?
What is a spinlock in linux?
Write an algorithm for inserting and deleting an element from doubly linked list?
Tell about accomplishment you are proud of...
Why do fires spark?
Why does the Solid state Rectifiers for 3-ph brake motors sometimes have 2 & sometimes 3 output terminals?
Do you know SQL? I know SQL but i don't have any experience...that's it..No more questions ...simply he said " you can leave for the day" ...guys prepare SQL Quires before attending interview in bank of america...
what are the performance views in an oracle rac environment?
Can a dimension table contain numeric values?
What is the use of "stderr()"?
What is bcnf?