EXL informatica Questions

0 Answers  

---

Why we use stored procedure transformation?

4 Answers  

---

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

---

What is the need for an etl tool?

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 exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

Write the advantages of partitioning a session?

0 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

What are the types of schemas we have in data warehouse.

0 Answers  

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---