Sign Up Login


  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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 / suvarna_joshi


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will impo..

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

Post New Answer

More Database Management Interview Questions

Which is better saving files in database or in file system?

0 Answers  

What is sql in dbms?

0 Answers  

How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

0 Answers   PUCIT,

Who proposed the relational model?

0 Answers  

How does distributed database work?

0 Answers  

What do you understand by cursor? Mention the different types of cursor?

0 Answers  

What is an ALERT ?

1 Answers  

Is it good to store image in database?

0 Answers  

what is the difference between securityand protection in dbms?

2 Answers  

What are the two types of indexes and explain them in detail?

0 Answers  

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

0 Answers   Oracle,

What is cold backup and hot backup (in case of oracle)?

0 Answers  

For more Database Management Interview Questions Click Here
Categories