i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
- 3 Answers
- 10075 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
How to call shell scripts from informatica?
Briefly describe lookup transformation?
How can we update a record in the target table without using update strategy?
What is the difference between source qualifier transformations source filter to filter transformation?
What is a filter transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is deployment group?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you take back up of repository?
How can informatica be used for an organization?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is transformation?
How can you define user defied event?
How we can create indexes after completing the loan process?
