table creation create table product(pro_id number(5),pro

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

Question Posted / meenakshi sundaram

1 Answers
5745 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Define atomicity and aggregation.

975

Explain primary key and composite key.

921

What is Normalization and its different forms?

952

Why is databases important in healthcare?

905

Explain the importance of partitioning.

914

What are the differences between hash join, merge join and nested loops?

935

What is a database in computer?

886

Explain the necessary techniques to control deadlocks?

831

What is tuple in rdbms?

1015

What is difference between database and file?

906

Define cursor.

960

Why normalisation is required?

901

Explain meant by 3-tier architecture?

884

How do I add a file to a database?

851

What do you mean by transparent dbms?

1345