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 4252Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 9105How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 11267When 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 17650Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 19444Post New IBM Informatica Interview Questions
What is event and what are the tasks related to it?
How you can create a table using maol (microsoft access object library)?
bag filter ,monitooringof exection/ co -ordination of site activities format
How can I make usb bootable?
What are your short-term goals?
If you want that your area managers can only see data from their region and you want to assign this restriction for a specific duration, how this can be achieved?
What are all the reasons to use the server resources monitor?
What are advices in spring?
What is advantage of categories? What is difference between implementing a category and inheritance?
How to stop the execution of php script?
What are the types of windows in sap script?
Can I reinstall windows live mail?
What is joomla and wordpress?
what is meant by k-rating in isolation transformer?what is k9, k14 stands for?
Why Amazon? How is it different from its competitors?