Answer Posted / guduri

i think mike is correect

What is the cumulative sum and moving sum?

1233

---

How do you load first and last records into target table?

1207

---

Explain about Informatica server process that how it works relates to mapping variables?

1122

---

What are junk dimensions?

1111

---

Difference between Target-based loading and constraint-based loading?

1040

---

State the differences between sql override and lookup override?

1279

---

How many number of sessions can one group in batches?

1215

---

How to generate sequence numbers without using the sequence generator transformation?

1252

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2294

---

Mention some types of transformation?

1094

---

What is the Process to creating lookup transformation in informatica

1086

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1334

---

generate date / time dimension in informatica

1159

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1194

---

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

1950

---