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)

Can we create two repositories on same database instance in oracle?

1014

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8126

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1110

---

What does “tail –f” command do and what is its use as an Informatica admin.

1029

---

What are the types of caches in lookup?

975

---

According to his methodology what all you need before you build a datawarehouse

1689

---

What will be the approach?

929

---

What is an aggregator transformation?

1030

---

What happens when a session fails and you click on recover?

1061

---

What is Cognos script editor?

4163

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9736

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133

---

Name the different lookup cache(s)?

1158

---

what is diff b/t sorter t/r and agg have the option sorter property...

2129

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4677

---