Interested to Buy Any Domain ? << Click Here >> for more details...
source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
- 7 Answers
- 12870 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abhinav prakash
1.Pass the ports to an expression t/r.
create a dummy port and give the value as '1'
2.Pass only the salary port to an Aggregator t/r.
Create a dummy port with the same data type and column name
and value as expression.
create o/p port:max(salary)
3.Join these 2 t/r using joiner and join on the dummy port.
ensure u have checked the sorted input option.
4Pass the o/p to the target.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the different options available for update strategy?
What is rank transform?
Informatica Checkpoints
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
explan ur project architecture?
What is domain and gateway node?
How to start a workflow using pmcmd command?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is option by which we can run all the sessions in a batch simultaneously?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
can we override a native sql query within informatica? How do we do it?
What is fact table? Explain the different kinds of facts.
Why update strategy and union transformations are active?
