Answer / pradosh

this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used

Answer / ramesh

At Knack systems we use Informatica to make data migration
projects more standardized, repeatable, and consistent.
Whether they are rationalizing, integrating, upgrading, or
migrating to enterprise applications, Our teams can reduce
project risk and cost and improve project predictability
with Informatica.

Informatica makes projects less risky, reduce costs, and
shorten their project cycle Times . It enables users to
migrate more data of a higher quality faster, which means
that we can deliver their projects at a lower cost, on
time, on budget, and without reductions to scope

In which circumstances that informatica server creates Reject files?

2 Answers  

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

How many transformations can be used in mapplets.

0 Answers  

---

Differnce between filter and router?

14 Answers   IBM,

---

difference between shortcut and reusable transformation?

2 Answers  

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

How do you implement configuration management in Informatica?

1 Answers  

---

scenario

1 Answers  

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---