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

What is example of database?

0 Answers  

What does select top 1 do in sql?

0 Answers  

How do I truncate a sql log file?

0 Answers  

How do I install microsoft sql?

0 Answers  

What is rownum?

0 Answers  

What is the difference between between and in condition operators?

0 Answers  

What is NOCOPY?

6 Answers   DELL,

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

When can we use the where clause and the having clause?

0 Answers  

Can u create a primary key with out unique index.

8 Answers  

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

What does select count (*) mean in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories