Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 4248 Views
- IBM, I also Faced
- E-Mail Answers
Answer / vas.chiky
take one copy of master table as table_copy.
add a new column say "numeric" to the existing master table.
truncate the master table.
In informatica designer,
1.table_copy as source and master table as target.
2.have one expression trasformation. add one field numeric
(integer datatype).
expression coundition: iff (old_value = 'Y',1,0)
provide the connections.
create new workflow and start. The data will be loaded to
| Is This Answer Correct ? | 4 Yes | 0 No |
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
what is target load plan
How many dimensions are there in informatica?
What are the different clients of powercenter?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
What is staging area?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
What are the out put files that the informatica server creates during the session running?
Teradata 
