Answer Posted / dilip ingole

using query

SELECT 'JAN' AS MONTHS,SUM(JAN) FROM CALADERQUERY
UNION
SELECT 'FEB' AS MONTHS,SUM(FEB) FROM CALADERQUERY
UNION
SELECT 'MAR' AS MONTHS,SUM(MAR) FROM CALADERQUERY
UNION
SELECT 'APR' AS MONTHS,SUM(APR) FROM CALADERQUERY;

What does refresh system mean, and what are its distinctive choice?

1186

---

How does the aggregator transformation handle null values?

1150

---

What is a connected transformation?

1124

---

What are the new features of Power Center 5.0?

1780

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015

---

how many types of dimensions are available in informatica?

1104

---

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

9145

---

tell me the rules and responsblites in our project(my project is development)

1933

---

What are session parameters ? How do you set them?

1854

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

---

What is the difference between informatics 7x and 8x and what is latest version?

1085

---

what is unit testing?tell me proceedure

2223

---

What are the informatica performance improvement tips

1096

---

How is union transformation utilized?

1013

---