Answer / mike

well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house

correct me if i was wrong

Answer / deepthi

etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

Which is the t/r that builts only single cache memory?

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 is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

8.what is mapplet ?give example?

2 Answers  

---