Answer Posted / jaybrata

have you guys heard of Informatica CUME() function?
Don't use seq generator, aggregator, sq override nothing.

Simply in a expression, calculate,
v_cume = CUME(1)

and after that in a filter use,
v_cume=1 OR v_cume=10

- Jaybrata
(Check www.dwbiconcepts.com)

Differentiate between joiner and lookup transformation?

1109

---

Can we override a native sql query within informatica?

1045

---

What is a filter transformation and why it is an active one?

973

---

Differentiate between reusable transformation and mapplet.

1105

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1691

---

Name the different lookup cache(s)?

1240

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2348

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1055

---

What is lookup transformation?

1047

---

How to do unit testing in informatica? How to load data in informatica ?

1135

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1911

---

How to implement security measures using repository manager?

1186

---

How can you generate reports in informatica?

1040

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1040

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2168

---