i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?
Answer Posted / upendra
In Informatica mapping we can find source A last record into Target B first record.
SRC-->Rank--> TGT
note:rank transformation edit propertities tab assign bottom=1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the different types of olap? Give an example?
what is the hint? how to use it to reduce the query processing in program?
What are connected or unconnected transformations?
difference between informatica 8.1.1 and 8.6
How to improve the performance of a session using sorter transformation?
How many dimensions are there in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the meaning of decode in informatica?
In informatica workflow manager, how many repositories can be created?
have u done any performance tuning? how u ll do?
What is a sequence generator transformation?
How do you promote a non-reusable transformation to reusable transformation?
Whats there in global repository
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?