Answer Posted / sukanta

Mapping is developed for what data will move to target,what
the modifications done upon that.Mapping is the collection
of source,target,transformations and mapplets.

Mapplets is only collection of transformations.It is a
reusable object and you can use it in any mapping for that
particular folder.Mapplet is meant for a particular complex
work done lets say sale tax calculation.
In mapplet you can use source but can't use another mapplet.

What are mapplets? How is it different from a Reusable Transformation?

618

---

What are the components of the workflow manager?

634

---

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?

1676

---

As union transformation gives UNION ALL output, how you will get the UNION output?

637

---

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

1541

---

---

Explain what is informatica metadata and where is it stored?

600

---

Design time, run time. If you don't create parameter what will happen

1416

---

What are the different types of repositories created using informatica?

651

---

What is the benefit of session partitioning?

588

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5557

---

What are the different components of powercenter?

575

---

What are the uses of etl tools?

639

---

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

1863

---

Repository user profiles

1370

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

700

---