Answer / Ankush Sharma

To reverse the contents of a flat file in Informatica, you can use the following steps: 1. Import the flat file and create a session. 2. Add a Sorter Transformation to sort the data in descending order (e.g., Sort Column1 Descending). 3. Save and execute the session.

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1 Answers  

---

what is the hint? how to use it to reduce the query processing in program?

4 Answers   Cegedim,

---

How to do the error handling of if ur source is flatfiles?

1 Answers  

---

how we can load rejected record's at run time?(not through bad files)

1 Answers   TCS,

---

have u done any performance tuning? how u ll do?

1 Answers   IMB, TCS,

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

how tokens will generate?

1 Answers  

---

can we override a native sql query within informatica? Where do we do it?

1 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---