Answer Posted / vinod kumar

copy the source for 3 times then total 4 sources will be
there in your mapping and move all sources to the target you
will get 4 times of same data in target

Explain in detail scd type 2 through mapping.

730

---

How do you load only null records into target?

837

---

In informatics server which files are created during the session rums?

730

---

Slowly changing dimensions, types and where will you use them

1362

---

What is the benefit of partitioning a session?

740

---

---

Whats there in global repository

1347

---

What are active and passive transformations?

724

---

What are the new features of informatica 9.x developer?

634

---

what is index?how it can work in informatica

1695

---

How to extract the informatica rejected data?

847

---

server hot-ws270 is connect to Repository B. What does it mean?

1977

---

What are the components of the workflow manager?

748

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1978

---

What is meant by a domain?

743

---

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

1534

---