Answer / ramu

informatica server moves data from source to target based on
workflow and mapping metadata stored in repository.

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

what is parameter file?

1 Answers   Cap Gemini,

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

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,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

what is galaxy repository?

2 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---