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
Which transformation should we use to normalise the COBOL and relational sources?
without table how to come first record only in oracle?
What is workflow manager?
Explain the types of lookup transformation?
What is the use of target designer?
What is InformaticaPowerCenter?
list out all the transformations which use cache?
What do you mean by worklet?
What is union transformation in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to create a non-reusable instance of reusable transformations?
How to load a Dimension ? and how to load a fact table?
Separate from a database, an information bazaar, and an information stockroom?
Explain what is informatica metadata and where is it stored?