Answer Posted / shaik

Create a mapping with two targets.

> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.

> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.

How do you promote a non-reusable transformation to reusable transformation?

766

---

Enlist some properties of sessions.

729

---

How an expression transformation differs from aggregator transformation?

709

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

748

---

Explain sessions and how many types of sessions are there?

675

---

---

What do you mean by blocking transformation?

674

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1772

---

How to generate sequence numbers using expression transformation?

729

---

Differentiate between reusable transformation and mapplet.

700

---

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

2407

---

What are the tasks that source qualifier perform?

722

---

How can a transformation be made reusable?

749

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

672

---

How to generate sequence numbers without using the sequence generator transformation?

749

---

without table how to come first record only in oracle?

1940

---