Answer Posted / narayan

Kindly forward the Informatica dumps to me to
narayan04@gmail.com

What are the different etl testing categories as per their function?

1078

---

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

3770

---

How to delete data which is not in source table?

1342

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2557

---

What are various etl tools in the market?

1008

---

Is apache nifi an etl tool?

962

---

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

968

---

What is cube grouping?

1084

---

what is the difference steps for data modeling?

2145

---

Can we create Hierarchies in generic datasources?

2384

---

how to load the data to fact table?

2705

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1895

---

Explain about etl data integration software?

893

---

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.

2056

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2177

---