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 Posted / 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 |
Post New Answer View All Answers
What is a checkpoint in dbms and when does it occur?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
What is first normal form in dbms?
What do you mean by checkpoints in dbms?
How many types of users in dbms?
What is system catalog or catalog relation?
Define data, entity, domain and referential integrity?
What are its two major subsystems of r?
What is the best free database software?
What is a data source (ds)?
What is a concurrency problem in dbms?
Define RDBMS.
Is there a database program for mac?
What are the importance of partitioning in dbms?
What is hashing in dbms?