Answer Posted / ankur saini er.ankur861@gmail.

Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1797

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

---

What are the types of presistent cache in look up tr.

2056

---

How to use pmcmd utility command?

1038

---

Mention few advantages of router transformation over filter transformation.

1023

---

is it possible to index the data in cache of lkp transformation ?

2030

---

What is the advantage of informatica?

1069

---

What are the static cache and dynamic cache in informatica?

1195

---

How union transformation is used?

1008

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038

---

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

7395

---

How many input parameters can exist in an unconnected lookup?

1547

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2038

---

How to load the data from people soft hrm to people soft erm using informatica?

1021

---

How do you migrate data from one environment to another?

1096

---