Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10989 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 |
what is diff b/t sorter t/r and agg have the option sorter property...
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a filter transformation?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how we load the data from source to staging area
can session assigned multiple mappings or not?
Label in Informatica. How to remove existing Label.
Explain informatica architecture - version 8 / 9
How to jion 2 tables, without using any condition?
What is a passive transformation?
Define enterprise data warehousing?
Teradata 
