NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
Answers were Sorted based on User's Feedback
Answer / abhinav
step1:Pass on the source(name,sal) to an expression
create a dummy port and give the value as 1.
In the expression transformation, the ports will be
Step2:Pass only the salary port from source to aggregator
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
Step3:Send the output from the 2 transformation to a joiner
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|
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
Then pass the output ports from expression to target table.
|Is This Answer Correct ?||0 Yes||0 No|
Answer / pjr
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|
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
what is the process of target load planing?
permutations of mapplet
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
tell me 7.x and 8.x diferrencess(but not transformations)
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Scheduling properties,whats the default (sequential)
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
what is the method of error handling when session is running?
Can anyone tell me the new features in Informatica 9 Version?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records