Answer / akash

I am not aware of conformed fact but conformed dimension
tables exist.
A conformed dimension is one which is used by more than one
fact table. A classic example of conformed table is a
dimension table which has date fields.

Please let me know if conformed facts exist and their
definition.

Answer / sanjay

A fact which can be used across multiple datamart is called
as confirmed fact. Confirmed fact allows having the same
name in different table.

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

what is the exact meaning of domain?

3 Answers  

---

how to use incremental load?

2 Answers   TCS,

---

What is the benefit of session partitioning?

0 Answers  

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---