Answer Posted / abhishek kumar

using union transformation.........

What is tracing level? How many types of transformations supported by sorted input?

913

---

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

917

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2837

---

how does the server recongnise the source and target databases.Elaborate on this

2623

---

Explain different types of partitioning?

959

---

what are the facilities provided by data warehouse to analytical users?

2009

---

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?

2117

---

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

2181

---

flat filevalidation in informatica

2088

---

what is the meant by Normalization and de-normalization?

2647

---

Can there be sub steps of etl steps?

939

---

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.

2003

---

what are the types in error loging?

2089

---

how to connect to a flatfile through ftp in informatica

14177

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1953

---