Answer Posted / abhinaw prakash

Select 'Abhi'||'+1' from Dual

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.

1843

---

How can we create index after completion of load process?

594

---

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 what are the different types of transformation available in informatica.

568

---

What is olap (on-line analytical processing?

637

---

---

How would you join a node to the already existing domain?

675

---

How big was your fact table

1310

---

State the limitations where we cannot use joiner in the mapping pipeline?

543

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1781

---

What do you mean by enterprise data warehousing?

638

---

Which is the t/r that builts only single cache memory?

706

---

Difference between Target-based loading and constraint-based loading?

548

---

What is workflow monitor?

593

---

What if the source is a flat-file?

586

---

What is meant by lookup transformation?

608

---