Answer / rajeshkumar

n number of cubes

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

How to delete duplicate row using informatica?

0 Answers  

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

What you know about transaction control transformation?

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,

---

What are the phases in SDLC?

3 Answers  

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---