Answer / brahma

using set count varriable in expression transformation.

Answer / kalu bhai

without using sequence genarerater and lookup, we can
create sequence numbers in two ways 1.using of expresson
transformation 2. stored procedure transformation,

Answer / guest

Using oracle database sequence gen(from dual table)

Answer / sk

Using
1. SQL Trx
2. Exp

Answer / naveen

by using mapping variable we can also create a sequence number

what is a transforamation?

5 Answers  

---

What is pmcmd command?

0 Answers  

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What is lookup transformation?

0 Answers  

---

How will you combine 3 different sources with a single source?

3 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---