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 >> SQL PLSQL
  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
101, LED Lights.
102, 20watt CFL Lights.
103, 30 watt CFL lights
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence.
flat file product
Prono,pro_name,
1, 20 watt tube light
2, 30 watt tube light
& target should be like
101, LED Lights.
102, 20watt CFL Lights.
103, 30 watt CFL lights.
104, 20 watt tube light
105, 30 watt tube light


thks reg
suvarna joshi
suvarnaatsuvarna@rediffmail.com

Question Posted / suvarna_joshi

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Is join an inner join?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

What type of database is sql?

0 Answers  

What is information schema in sql?

0 Answers  

Explain cursor types?

0 Answers  

What is join view in sql?

0 Answers  

what are the different index configurations a table can have? : Sql dba

0 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

What are the usage of SAVEPOINTS?

5 Answers  

How global cursor can be declare with dynamic trigger ?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories