What are the designer tools for creating transformations?

0 Answers   Informatica,

---

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

---

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

What are the scheduling options to run a sesion?

2 Answers  

---

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

Explain the aggregator transformation?

0 Answers  

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

To provide support for Mainframes source data,which files r used as a COBOL files

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

---