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
- 11095 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 |
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how to insert header after each group.
What is the difference between Active and Passive transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
without using emailtask how will send a mail from informatica?
What is CDC? How to implement CDC?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Teradata 
