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 |
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
What is DTM process?
what is Partitioning ? where we can use Partition?
how we can load rejected record's at run time?(not through bad files)
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
What is log file,and where is it located,why u r using the log file
what is curr val use for in sequence generator?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a repository? And how to add it in an informatica client?
can we load the data with out a primary key of a table? what is target plan?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?