Interested to Buy Any Domain ? << Click Here >> for more details...
i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
- 3 Answers
- 11691 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
without using emailtask how will send a mail from informatica?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
how to use incremental load?
What are the different options available for update strategy?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
What are the new features of informatica 9.x in developer level?
What is resilience time?
What is batch and describe about types of batches?
Teradata 
