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 are the benefits of database management system?
where a Database Procedure is stored ?
can Constraints cannot be exported through EXPORT command ?
2 Answers Grasim, Oracle, Suvidha,
Can you explain insert, update and delete query?
Why is the use of dbms recommended?
What is a database in healthcare?
What is a data source (ds)?
i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com
How do I convert a spreadsheet to a database?
Can an Alert message be changed at runtime ?
What do you understand by cursor?
What are the importance of database in banking?