Answer / Sunil Kumar Jayasawal

In Informatica, a role-playing dimension is a dimension that plays multiple roles in a fact table. For example, a customer can also be a vendor, so the customer dimension could be used to populate both the customer and vendor facts.

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

What are the rank caches?

2 Answers   Informatica,

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

Briefly describe lookup transformation?

1 Answers  

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1 Answers  

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

what is mapping override?

2 Answers   Cap Gemini,

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

How can you access the remote source into your session?

1 Answers  

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---