Answer Posted / thirumal

Create reusable sessions in the Task Developer. When you
create a reusable session, you can use it in multiple
workflows.
example :Session Task,
Email Task,
Command Task


Create non-reusable sessions in the Workflow Designer. When
you create a non-reusable session, you can use it only in
that workflow.

Name at least 5 different types of transformations used in mapping design and state the use of each.?

919

---

What is dimensional table? Explain the different dimensions.

928

---

Can we get 1st record through Informatica(without sequence number).

1227

---

How to load a Dimension ? and how to load a fact table?

1163

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

865

---

Mention few advantages of router transformation over filter transformation.

851

---

How would you copy the content of one repository to another repository?

789

---

where to store informatica rejected data? How to extract the informatica rejected data?

806

---

What is the fact table?

803

---

Different sorts of metadata that stores in the storage facility?

795

---

define galaxy repository in informatica

1957

---

What is a shortcut and copy in Informatica and how two are different with each other?

952

---

I have a flat file, want to reverse the contents of the flat file

924

---

Explain the different kinds of facts.

766

---

What are the advantages of informatica?

775

---