Answer Posted / gaurav

Please send to gmunot@gmail.com. Thanks in advance

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1972

---

What are the modules in Power Mart?

970

---

what is the use of server?

2208

---

Is apache nifi an etl tool?

976

---

What are snapshots?

989

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2067

---

What is partitioning? Explain about round-robin, hash partitioning.

980

---

What is the difference between round-robin partitioning and hash partitioning?

977

---

How many steps etl contains explain with example?

978

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1796

---

how to connect to a flatfile through ftp in informatica

14315

---

What is lookup table in etl testing?

1194

---

flat filevalidation in informatica

2161

---

how to load the data to fact table?

2715

---

if i have a query as flat file how can we load data to target table

1406

---