source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / james
select name,no,sal,(select max(sal) from emp) as max_sal
from emp;
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
What is informatica?
What is the benefit of partitioning a session?
What are active transformations.
How to create or import flat file definition in to the warehouse designer?
What does role playing dimension mean?
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.
What do you mean by worklet?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Design time, run time. If you don't create parameter what will happen
Whats there in global repository
What is workflow? What are the components of workflow manager?
What is the sequence generator transformation in informatica?
During the running session, output files are created by informatica server. Enlist few of them.