Answer Posted / jayesh

Filter in source qualifire itself..in sq query or sq filter.

explain about unit testing? in real time?

2210

---

What is workflow manager?

1055

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1712

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

Explain the aggregator transformation?

1173

---

How can you differentiate between powercenter and power map?

1094

---

What are roles and groups and benefits of using them?

1057

---

To import the flat file definition into the designer where should the flat file be placed?

1061

---

waht type of interface is used for testing the data in informatica

2259

---

Explain target update override in informatica

1129

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7399

---

Slowly changing dimensions, types and where will you use them

1719

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2148

---

What do you understand by SOA of Informatica?

992

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1066

---