Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 10606 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / priyank
In Informatica, make table A as Source and follow the below
mapping:
SRC_A --> AGG --> TGT_B
AGG: Do not check any of the columns for group by and pass
the output to target B. In this way, only the last row will
be passed through.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is rank index in rank transformation?
what is index?how it can work in informatica
What happens when a session fails and you click on recover?
What is an unconnected transformation?
What is complex mapping?
What is a mapplet/worklet in informatica?
What are the tuning techniques you applied during your last project
State the differences between sql override and lookup override?
without table how to come first record only in oracle?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What could be the possible resons of locks by user?
What are the different versions of informatica?
How to go to the older version for a mapping?
How do you take back up of repository?
