Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

How many repositories can be created in informatica?

1 Answers  

---

How to open an older version of an object in the workspace?

0 Answers  

---

What is the need of building a data warehouse?

2 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,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---