Answer / hari

generate , delimited file with file extension .csv.
open that one excel u can get excel output data.

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

What is metadata reporter?

1 Answers   Informatica,

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

What do you mean by blocking transformation?

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 left outer join?

3 Answers   L&T,

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

---