How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

What if the source is a flat-file?

0 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

---

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

State the differences between sql override and lookup override?

0 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---