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
- 10443 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 rank transformation in informatica
What is Data Caches size?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Why union transformation is an active transformation?
How do you handle two sessions in Informatica
How do you convert single row from source into three rows into target?
Explain in detail about scd type 1 through mapping.
What is data movement mode in Informatica and difference between them?
How an expression transformation differs from aggregator transformation?
What is repository manager?
What is the scenario which compels informatica server to reject files?
tell me about your project functionality
What is persistent lookup cache?
What is standalone command task?
Explain constraint based loading in informatica
