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 4068Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 8801How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 10926When 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 17352Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 18576Post New IBM Informatica Interview Questions
Name the implicit member functions of a class.
Explain the domain creation types?
usually hand broken stones are used for cement concrete 1:4:8 in foundation of single /two story houses with a view of economy in construction.what advantages it will give if you use machine crushed stone in place?
In which folder robot.txt is placed?
What is DiffGram in XML?
What are the 8 elements of design?
hii exparts plz give me one example of business process of a company..plz plz.... kumarcrm11@gmail.com
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is the command to check the os version in windows?
Explain the difference between severity and priority.
What is context path in tomcat?
Which elements constitute the administrative personnel structure?
Does hibernate cache data?
What are the disadvantages of linked list?
using examples, examine the relevance of the following as final accouting adjustments; 1.reserves 2.provisions 3.disposal of assets 4.control accounts