how to sort date field in infomatica?

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

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

---

what is dynamic cashe

3 Answers   Informatica,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

Why do we need informatica?

0 Answers  

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---