Answer Posted / uzval_vee

Place the agg transformation after souce qualifier,becoz
if yur using filter,sorting before agg ,it will reduce the
agg performance .according to my view

How can you increase the performance in joiner transformation?

1203

---

Define the various join types of joiner transformation?

991

---

How might you approve all mappings in the archive all the while?

1021

---

What is joiner change?

1154

---

list out all the transformations which use cache?

1190

---

Briefly describe lookup transformation?

1051

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1913

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9154

---

can u give example for factless fact table

6666

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2152

---

What is rank index in rank transformation?

1084

---

Mention some types of transformation?

1051

---

What are the new features of Power Center 5.0?

1789

---

How many input parameters can exist in an unconnected lookup?

1558

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1264

---