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
- 10943 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 any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What does “tail –f” command do and what is its use as an Informatica admin.
complex mapping ur project u r invlve can u explain and give real time example give me ?
Define mapplet?
What are multi-group transformations?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the informatica performance improvement tips
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the meaning of up gradation of repository?
What are the types of caches in lookup? Explain them.
Enlist the various types of transformations.
Explain why we use partitioning the session in informatica?
How to create the source and target database connections in server manager?
How can you validate all mappings in the repository simultaneously?
how to load rows into fact table in data warehouse
