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 4039Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
3 8771How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
4 10886When 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 17328Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
11 18472Post New IBM Informatica Interview Questions
What is amazon free tier instances?
Is tcp or udp better for streaming?
Explain the role of $routeprovider in angularjs?
what is actual flag?
What is inert pair effect?
What are the looping structures available in ruby?
What are abstract classes in c#?
What ethical challenges may arise when recommending surgical interventions for cosmetic purposes, such as refractive surgery?
From the following particulars taken on 31 December, 1995, you are required to prepare a bank reconciliation statement to reconcile the bank balance shown in the Cash Book with that shown in the Pass Book: (i) Balance as per Pass Book on 31 December, 1995, O/D Rs 1,027. (ii) Four cheques drawn on 31 December but not cleared till January are as follows: Rs 12; Rs 1,021; Rs 98; and Rs 113. (iii) Interest on O/D not entered in Cash Book Rs 51. (iv) Three cheques received on 30 December and entered in the bank column of the Cash Book but not lodged in bank for collection till 3 January next: Rs 1,160; Rs 2,100; and Rs 2,080. (v) Cost of cheque book, Pass Book, etc; Rs 1.50 entered twice erroneously in Cash Book in November. (vi) A Bill Receivable for Rs 250 due on 29 December, 1995 was passed to the bank for collection on 28 December, 1990 and was entered in Cash Book forthwith whereas the proceeds were credited in the Pass Book only in January following. (vii) Chamber of Commerce subscription Rs 10 paid by bank on 1 December, 1990 had not been entered in the Cash Book. (viii) Bank charges of Rs 5 had been debited in the pass book twice erroneously. . . . plz be fast
institutional investors?
What is the eligibility criteria of C-Form(Manufacturing goods of borewell bits, Hammers, Drilling Tools and Air compressors, etc..). If such company will purchase safety shoes, buyer can eligible to issue C-Form?
How can you get the google cache age of any url or web page?
What is the difference between tables and structures?
Explain what is the use of defpararm?
Define the term string pool?