Answer / anonymous

https://uisapp2.iu.edu/confluence-prd/display/EDW/PowerCenter+Errors

This link is good.

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,

---

replace multiple spaces with single space.

3 Answers   IBM,

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

What is galaxy shema

2 Answers   CGI,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---