Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 9391 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / informatica
use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / swarup
sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)
| Is This Answer Correct ? | 1 Yes | 0 No |
What will be the approach?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What are the two modes of datamovement in informatica sever?
How will you convert rows into columns or columns into rows
What are Dimensional table?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
In which scenario did u used Mapping variable?
What is the fact table?
what is dimension table?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is rank transformation in informatica
Teradata 
