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
5852 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

What is dbms and types of dbms?

1088

How to prevent firebird.log file from filling up the disk partition?

929

Have you written applications to retrieve stored images in a table?

1022

What is a system concept?

920

Which database is used by google?

988

Is there a database program for mac?

936

Explain ddl interpreter?

1196

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?

997

What is trigger in dbms?

926

What is local database?

980

Enlist the various transaction phases.

1045

Explain armstrong rules? How they are complete and/or sound?

902

How to unzip a file in ssis?

1067

What is rdms?

939

Explain what are tp-lite and tp-heavy monitors?

918