Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10524 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
FOR THIS WE HAVE 2 USE TWO T/R ie FIRST WE HAVE 2 USE RANK T/R
AND THEN USE A FILTER T/R IN FILTER GIVE THE CONDITION AS
RANK=5 CONNECT TO TARGET
THE FLOW IS LIKE THIS
SRC --->SQ--->RANK--->FILTER--->TRG
WE CAN ALSO DO THIS IN SQL USE THE FOLLOWING QUERY
SELECT * FROM <TABLE_NAME> WHERE ROWNUM <= 5 MINUS SELECT *
FROM <TABLE_NAME> WHERE ROWNUM <=4;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How can repository reports be accessed without sql or other transformations?
What is the command used to run a batch?
What do you understand by term role-playing dimension?
How to create a non-reusable instance of reusable transformations?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the scenario which compels informatica server to reject files?
What are the mapping parameters and mapping variables?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the types of caches in lookup?
What are the transformations that are not supported in mapplet?
What are data-driven sessions?
Is there any target staging area in informatica not staging area
