Answer Posted / priya

look up transformation is used to look the data either from
source or target whenever the req feild is not in the
mapping.
we can use two or more tables as look up by using the join
condition

How can we delete duplicate rows from flat files?

744

---

What is the difference between Active and Passive transformation?

634

---

What is source qualifier transformation in informatica?

575

---

What is exclusive and normal mode for repository services?

713

---

Explain Dataware house architecture .how data flow from intial to end?

2125

---

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10280

---

what is SDLC way of code development?

1561

---

How to do unit testing in informatica? How to load data in informatica ?

653

---

Parameter and variable differences

1615

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

628

---

explain one complex mapping with logic? sales project?

6150

---

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

1411

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1054

---

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

623

---