i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
Answers were Sorted based on User's Feedback
Answer / pradeepa
We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / syed
we can also use rank transformation by setting top, no of
rank =1 and enable group by port deptno
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / janardhanreddy yerraballi
select deptid, empname, salary from
(Select deptid, empname,salary,
rank() Over(Partition by deptid order by salary desc)as rank from
EmpDetails) emp
where emp.rank = 1
Is This Answer Correct ? | 1 Yes | 0 No |
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
How to display First letter of Names in Caps?
What you know about transaction control transformation?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
i have 2 session s1 execute s2 load first session fail what is the reason?
What is parallel processing in informatica?
What are the differences between a connected lookup and unconnected lookup?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What are the data movement modes in informatica?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?