Answer / jz

If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.

Answer / santosh kumar sarangi

you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.

Answer / sukanta

You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.

You will get the solution.I check it.

Regards
Sukanta

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

Define Incremental Aggregation?

2 Answers  

---

how do u tune queries?

1 Answers  

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

What is lookup change?

0 Answers  

---

How to recover the standalone session?

2 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---