Answer / abhinaw prakash

Data warehouse is the coordinated,periodic copying of data
from different sources both inside and outside the
enterprise into an environment optimized for analytical and
informational processing.

By Historical data means that historical data will also be
kept along with the most recent data unlike the OLTP system.

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

What are the designer tools for creating transformations?

0 Answers   Informatica,

---

What is meant by query override?

0 Answers  

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

How to start a workflow using pmcmd command?

0 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

What is status code?

2 Answers  

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---