Answer / isha

In stored procedure transformation,

We have option to select source procedure types. Pre-load means - RUN the PROCEDURE before SQ executes the data.

Explain about cumulative Sum or moving sum?

1 Answers   Informatica,

---

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

What all are steps in up gradation of Informatica server?

1 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

---

Enlist the advantages of informatica.

1 Answers  

---

Is it possible to revert a global repository to local one and why?

1 Answers  

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

What are some examples of informatica etl programs?

1 Answers  

---