SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
- 5 Answers
- 9230 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / davankumar
select name,sal,(select max(sal) from t1) from t1
| Is This Answer Correct ? | 1 Yes | 0 No |
orcle level you are 100% correct but in informatica level
how to configure mapping
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pjr
SQ-->Agg-->TGT
in aggrigator create on new out_port max_sal=max(sal) then
give connection to tgt MXASAL
| Is This Answer Correct ? | 0 Yes | 4 No |
How can i send first half of the records to one target and Remaining to other target?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Where do we use mapping variables in informatica?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
State the limitations where we cannot use joiner in the mapping pipeline?
What is meant by query override?
write a query to retrieve the latest records from the table sorted by version(scd)
Can you create a flatfile target
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
what is dynamic cashe
A session S_MAP1 is in Repository A. While running the session error message has displayed
Teradata 
