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.

Enlist the differences between database and data warehouse.

1050

---

How can one identify whether mapping is correct or not without connecting session?

1387

---

Slowly changing dimensions, types and where will you use them

1669

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1017

---

Explian the Process of deployment groups in informatica

1001

---

list out all the transformations which use cache?

1128

---

What is a snowflake schema?

935

---

What all join we can perform in LOOKUP transformation?

926

---

Explain the use of aggregator cache file?

1200

---

Explain sessions. Explain how batches are used to combine executions?

960

---

What is the Rank index port in Rank transformation?

1020

---

What is the sql query overwrite in source qualifier in informatica

1037

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2238

---

Does an informatica transformation support only aggregate expressions?

984

---

Explain direct and indirect flat file loading (source file type) - informatica

1275

---