Answer Posted / kamleshmishra291

SQ->EXP->NRM->TGT

EXP :-- CREATE 4 OUTPUT PORTS
PORT1= 'JAN'
PORT2='FEB'
PORT3='MAR'
PORT4='APRIL'
AGGR :-- DRAG ALL PORTS FROM EXP AND CREATE 4 OUTPUT PORT
PORT5= SUM(JAN)
PORT6=SUM(FEB)
PORT7=SUM(MAR)
PORT8=SUM(APRIL)
NRM : CREATE 2 PORTS
MONTHS- OCCUR(4)- STRING
TOTAL- OCCUR(4)- NUMBER
CONNECT NRM OUTPUT PORT TO TGT

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2802

---

Enlist the tasks for which source qualifier transformation is used.

982

---

What do think which one is the better joiner or look up?

1144

---

How to create Target definition for flat files?

1159

---

What are the types of schemas we have in data warehouse and what are the difference between them?

891

---

what are 3 tech challenges/ common issues you face?

2282

---

What is the way to execute pl/sql script using informatica mapping?

1511

---

what is the -ve test case in your project.

2332

---

How do you load first and last records into target table?

1101

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

---

What is powercenter on grid?

1129

---

How can we remove the duplicates from flat file source?

950

---

What is the command used to run a batch?

997

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1119

---

On which transformations you created partitions in your project?

1254

---