Answer Posted / gm

SQL:
select quarter, sales from table_name
group by quarter, sales;

Informatica:
Source-SQ-Exp-Normalizer Trans.-Tgt
In Normalizer Transformation we can do row into column.

What are the issues you have faced in your project? How did you overcome those issues?

2365

---

How to create Target definition for flat files?

1225

---

What are the transformations that are not supported in mapplet?

1029

---

How to load the data from people soft hrm to people soft erm using informatica?

1017

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

Explain pmcmd command usage in informatica

1133

---

What is a stored procedure transformation?

1054

---

Explain the features of connected and unconnected lookup.

935

---

Define mapplet?

1009

---

Explain how many types of dimensions are available in informatica?

1098

---

Design a mapping to load a target table with the following values from the above source?

1346

---

What is standalone command task?

1315

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

---

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

9135

---