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
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
- 2559 Views
- TCS, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How will you delete a particular row from a Table?
How many postgresql users are there, worldwide?
What is clause in sql?
what are the drivers in mysql? : Sql dba
What is pl sql in dbms?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
What are the types of triggers in sql?
what are numeric data types? : Sql dba
How do I find duplicates in sql?
Does sql profiler affect performance?
What is sql not null constraint?
-
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)
