Answer / 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.

Answer / davankumar

select name,sal,(select max(sal) from t1) from t1

Answer / gangadhar799

orcle level you are 100% correct but in informatica level
how to configure mapping

Answer / shekar

After source qulifier add a expression transformation in
the expression transformation create out put port name it
as maxsal then derive the code for this out put port as
setmaxvariable(sal).
Then pass the output ports from expression to target table.

Answer / pjr

SQ-->Agg-->TGT

in aggrigator create on new out_port max_sal=max(sal) then
give connection to tgt MXASAL

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

What are the data movement modes in informatcia?

3 Answers  

---

What is an expression transformation in informatica?

0 Answers  

---

Explain how to import oracle sequence into informatica?

0 Answers  

---

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

Informatica and datawarehousing courses in Pune?

2 Answers  

---