what is left outer join?

3 Answers   L&T,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

in which situations do u go for scds ?

3 Answers   TCS,

---

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

How to generate sequence numbers?

0 Answers  

---

what is the flow?

1 Answers  

---

What is the status code?

1 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

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,

---