Answer / kt

We need to use NORMALIZER transformation to convert single
row into multiple rows.

Ex: NAME SALES QUARTERCID KT_NRMSALES_ID
Books 10 1 1
Books 20 2 2
Books 30 3 3
-----etc
TO --> NAME Q1 Q2 Q3
Movies 40 30 70
Books 10 20 30
Furniture 20 10 90

And we need to use aggregator tranformation to do reverse
operation.

In this we have to use any of the aggregate function
SUM/MIN/MAX and then decode to get the particualr quarter
and enable NAME port as group by.
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q1
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q2
sum(DECODE(QUARTERCID,1,SALES,NULL)) Q3

Answer / ani

We cannot use normalizer transformation in this case.
It used for normalizing the records.
Use decode in expression transformation and then aggregator
transformation.

Answer / kalyan

Using Normalizer T/R we can achieve this; Horizantal
Pivoting i.e Coverting Single horizantal record into
Multiple vertical records. Even reverse logic i.e; Vertical
Pivoting also possible using the Normalizer T/R.

Please correct me if I am wrong !!

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

4 Answers   CSC,

---

How many joins in Informatica

5 Answers   CSC,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

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

0 Answers  

---

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---