Hi how to import oracle sequence in Informatica? Please
write stored procedure code that will import oracle sequence
in Informatica SP transformation as per below scenario
Oracle table product list
Pro_id, pro_name, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
pro_name, price
20 watt tube light ,45
30 watt tube light ,60
Answer / meenakshi sundaram
table creation
create table product(pro_id number(5),pro_name varchar2
(15),price number(5));
insert the value in table:
insert into product values(101,'led lights',200);
insert into product values(102,'20 watt cfl lights,145);
insert into product values(103,'30 watt cfl lights,155);
or
insert into product values(&pro_id ,'&pro_name',&price);
Is This Answer Correct ? | 0 Yes | 1 No |
What is pcbs (program communication blocks)?
What is equi-join?
Why do we need to use a database?
What is index hunting and how does it help in improving query performance?
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
0 Answers Indian Web Technology,
What are the various Database states.
How do you start a database?
What is sonicmq?
What is structure of dbms?
What is 3nf in dbms?
What is use of dbms?
What is meant by a database?