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 8988How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 11123When 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 17532Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 19044Post New IBM Informatica Interview Questions
What is Keyman Insurance?
Tell me how to store related field data into database?
What are new features added in nfs4?
How to customize qtp?
what is the journal entry for sales on discont. what is the journal entry for purchase on diicount.
What is the purpose of the err object in the vbscript language?
what is Gauge?
How you can create a folder using terminal?
What is dao layer in spring?
What is the mro in python?
what are the advantages of using them.
After entering the data from the front-end application interface, how do you test whether a database is updated or not?
Can we define apex sharing reason for standard object? : salesforce sharing and security
Why are the recent changes in the banking industry?
What is the control action?