Answer Posted / vasu

check all pevious Questions and Answers in
Allinterview.com

How to generate sequence numbers?

1098

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1088

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1096

---

How many ways are there to do 'remove duplicate records in informatica'?

1026

---

What is source qualifier transformation in informatica?

1020

---

What are mapplets? How is it different from a Reusable Transformation?

1105

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10193

---

What is the function of aggregator transformation?

1094

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6503

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2076

---

Explain sessions. Explain how batches are used to combine executions?

1042

---

What is workflow monitor?

1069

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1922

---

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

1979

---

What are the limitations of joiner transformation?

1117

---