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
- 10685 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
Can you generate sequence numbers without using the sequence generator transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is primary and backup node?
Global and Local shortcuts. Advantages.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is aggregate cache in aggregator transformation?
In informatics server which files are created during the session rums?
What is dimensional table?
define galaxy repository in informatica
what is mean by complex business rule ?
What are the limitations of joiner transformation?
What is parallel processing in informatica?
Explain about cumulative Sum or moving sum?
What is the surrogate key?
if we have a delimiters at unwanted places in a flat file how can we over come those.
