Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

0 Answers  

What is the full meaning of dbms?

0 Answers  

How the status of the Rollback segment can be viewed ?

1 Answers  

What is Mirrored on-line Redo Log ?

2 Answers  

What is dba in dbms?

0 Answers  

How does index hunting help in improving query performance?

0 Answers  

Can we attach the same List of Values to different fields in Design time ?

1 Answers  

Why would someone use a database?

0 Answers  

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

0 Answers  

What is third normal form?

0 Answers  

What is dbms and its functions?

0 Answers  

What is field record and table in database?

0 Answers  

For more Database Management Interview Questions Click Here
Categories