Answer Posted / pooja

HERE YOU MENTIONED ONLY 3 TRANSFORMATION, SO OUT THESE 3
aGGREGATOR IS COSTLIEST TRANS

What are the informatica performance improvement tips

1152

---

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

7503

---

How to load data in informatica ?

1070

---

Different qualification between a related rotate toward the sky and isolates look upward?

1039

---

What do you mean by enterprise data warehousing?

1109

---

What is a dimensional model?

1034

---

What are active transformations.

1704

---

Is there any target staging area in informatica not staging area

2631

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2797

---

where to store informatica rejected data? How to extract the informatica rejected data?

1057

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1693

---

What does “tail –f” command do and what is its use as an Informatica admin.

1147

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1213

---

What are the static cache and dynamic cache in informatica?

1245

---

What is the function of look up transformation?

1177

---