Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

why do u use shortcuts in informatica.?

4 Answers   iFlex,

---

Do you find any difficulty while working with flat files as source and target?

0 Answers  

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

What are the tasks that Loadmanger process will do?

1 Answers  

---