i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
Answer Posted / 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 |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is decode in static cache?
What is union transformation?
Which is the t/r that builts only single cache memory?
How to create the source and target database connections in server manager?
How can informatica be used for an organization?
Explain your project of banking domian.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Name the different lookup cache(s)?
Enterprise data warehouse your projects phase by phase explain?
Does an informatica transformation support only aggregate expressions?
How can one identify whether mapping is correct or not without connecting session?
Explain scd type 3 through mapping.
Describe the impact of several join conditions and join order in a joiner transformation?