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

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

What is row_number () in sql?

0 Answers  

How delete a row in sql?

0 Answers  

What does closing a cursor do?

0 Answers  

Are there any features that are decommissioned in 11g that are not present in 11g?

0 Answers  




What is exception? What are the types of exceptions?

0 Answers  

Do we need to create index on primary key?

0 Answers  

How do I truncate a word?

0 Answers  

What makes a good primary key?

0 Answers  

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

What are the pre requisites?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories