Answer Posted / abhinav

step1:Pass on the source(name,sal) to an expression
transformation.
create a dummy port and give the value as 1.

In the expression transformation, the ports will be

Name
sal
O_dummy=1

Step2:Pass only the salary port from source to aggregator
transformation.
create a dummy port with the same data type as in expression
and give the value as 1
create an output port with Max(Salary)

In the aggregator transformation, the ports will be
sal
O_dummy
O_sum_salary=max(salary)

Step3:Send the output from the 2 transformation to a joiner
transformation.
Ensure you have checked the sorted input option.
Join both the transformation on the Dummy port.

Step4:Send the output to the target.

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

2091

---

What are the transformations that are not supported in mapplet?

952

---

What is a repository manager?

1026

---

What is rank index in rank transformation?

1008

---

What is joiner transformation in informatica?

992

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2506

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2047

---

Plz can any one say me how to get the informatica certification materials and dumps

1998

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1003

---

what is the difference between informatica6.1 and infomatica7.1

2179

---

In informatica workflow manager, how many repositories can be created?

1259

---

What is incremental aggregation?

1011

---

How to create Target definition for flat files?

1154

---

What is the scenario which compels informatica server to reject files?

1006

---

Is stop and abort are same in informatica?

943

---