Answer Posted / thiru

In normal loading it will creates the log file before
loading target.it will takes the time but in this sessiom
recovery is available.

In bulk loading the integration service bypasses the log
file,direct load into the target.inthis there is no session
recovery available but performance increase.

How to load data in informatica ?

568

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4968

---

What is the need for an etl tool?

631

---

What is a stored procedure transformation?

607

---

What do you understand by SOA of Informatica?

583

---

---

What the difference is between a database, a data warehouse and a data mart?

591

---

What is an Integration service in Informatica?

699

---

Explain target update override in informatica

629

---

Clarify the utilization of aggregator cache record?

575

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1759

---

list out all the transformations which use cache?

685

---

What do you understand by term role-playing dimension?

570

---

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

549

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1042

---

Explain the difference between a data warehouse and a data mart?

594

---