Answer Posted / eric yang

De-normalized data can save more space and have better
performance when run a sql for it

Can we create two repositories on same database instance in oracle?

829

---

Explain about Informatica server process that how it works relates to mapping variables?

808

---

Slowly changing dimensions, types and where will you use them

1456

---

Explain the aggregator transformation?

835

---

How to convert multiple rows to single row (multiple columns) in informatica

1109

---

---

Explain incremental aggregation in informatica

848

---

How you prepared reports for OLAP?

1333

---

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?

1267

---

Define joiner transformation?

786

---

What is the format of informatica objects in a repository?

791

---

Why is sorter an active transformation?

863

---

Differentiate between source qualifier and filter transformation?

1263

---

What is the difference between a repository server and a powerhouse?

1116

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1711

---

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.

2040

---