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

What do you understand by a term domain?

0 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

"Change cache" in Informatica ?

2 Answers  

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

Which kind of index is preferred in DWH?

3 Answers  

---

How union transformation is active ?

2 Answers   Puma,

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---