Answer Posted / prakash m

A convenient grouping of random flags and attributes to get
them out of the fact table
Retain only useful fields
Remove fields that make no sense at all
Remove fields that are inconsistently filled
Remove fields that are of operational interest only
Design similar to demographics; maximum unique
combinations, assign integer key, plug into fact
Create new combination (insert new dimension record) at ETL
run-time
E.g. Yes/No Flags in old retail transaction data

What is meant by incremental aggregation?

1178

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1674

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1855

---

What is the commit type if you have a transaction control transformation in the mapping?

1094

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2186

---

What are mapplets?

1324

---

permutations of mapplet

2546

---

how tokens will generate?

2247

---

Design time, run time. If you don't create parameter what will happen

1890

---

Under what condition selecting sorted input in aggregator may fail the session?

1170

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

---

What is resilience time?

1220

---

In informatica workflow manager, how many repositories can be created?

1435

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1794

---

What are the mapping parameters and mapping variables?

1267

---