Interested to Buy Any Domain ? << Click Here >> for more details...
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, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
pro_name, price
20 watt tube light ,45
30 watt tube light ,60
- 1 Answers
- 5835 Views
- TCS, I also Faced
- E-Mail Answers
Answer / meenakshi sundaram
table creation
create table product(pro_id number(5),pro_name varchar2
(15),price number(5));
insert the value in table:
insert into product values(101,'led lights',200);
insert into product values(102,'20 watt cfl lights,145);
insert into product values(103,'30 watt cfl lights,155);
or
insert into product values(&pro_id ,'&pro_name',&price);
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain the different types of constraints in dbms?
What is actional flow mapping?
Explain the term specialization.
Where the Databases overall structure is maintained ?
how to generate an auto incremental number in a ssis package?
Why do we study dbms?
What is data modelling techniques?
Do I need ccp4?
Is dynamodb a document database?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
Can I concurrently access a firebird database with embedded and with regular server?
What is rank in database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
