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
- 0 Answers
- 2058 Views
- TCS, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do I partition a table in sql?
what are local and global variables and their differences? : Sql dba
Give which cursor is better for better performance means type of cursors?
What is the difference between having clause and where clause?
What are sql injection vulnerabilities?
Define overloaded procedure?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the different sql languages?
What is the need of merge statement?
Explain how to use transactions efficiently : transact sql
What is db journal file?
What is gpt format?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
