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
- 11695 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 |
How do you manage the Parameter files while migrating your data from one environment to another environment?
How many ways are there to do 'remove duplicate records in informatica'?
How to recover the standalone session?
how to get flatfile containg 10 records half records one target another half another target
What is dimensional table?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
What is the different lookup cache(s)?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
how do u move the code from development to production?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Teradata 
