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
- 11545 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a code page?
What is meant by target load plan?
Is it possible to revert a global repository to local one and why?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a node in Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What's the layout of parameter file (what does a parameter file contain?)?
complex mapping ur project u r invlve can u explain and give real time example give me ?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Is there any target staging area in informatica not staging area
Define sessions in informatica etl?
Target increases every day even though no new record was inserted
What is an expression transformation?
What is informatica powercenter repository?
write a query to retrieve the latest records from the table sorted by version(scd)
