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

Does group by remove duplicates?

0 Answers  

what is rollback? : Sql dba

0 Answers  

Is sql procedural language?

0 Answers  

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

What are the advantages of the packages

6 Answers   Oracle,

What are tuples in sql?

0 Answers  

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

What are the types of records?

0 Answers  

Are null values same as that of zero or a blank space?

0 Answers  

What is Overloading of procedures ?

4 Answers   Amdocs,

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

What is difference between my sql and sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories