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 4172Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 9011How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 11139When 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 19102Post New IBM Informatica Interview Questions
How ajax work ?
What is modulation? Explain in detail.
What are the basic Differences between Automation Anywhere and Blue Prism?
What is a hypertext link?
what is stressing
Please explain what is a relative xpath?
Have you done any parameter changes using configtool and visual admin tool?
What are the protocols supported by wcf hosting environment?
How to change the priority of thread or how to set priority of thread?
Explain binding of instructions and data to memory?
What is the role of compatibility that is used in android?
What is wrong with this statement? Myname = 'robin';
What is an expensive query?
How many levels of indirection in pointers can you have in a single declaration?
What is flexfileds and use of flexfileds in odi?