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 is the command used to run a batch?
list out all the transformations which use cache?
How union transformation is used?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the commit type if you have a transaction control transformation in the mapping?
What are the advantages of using informatica as an etl tool over teradata?
What are the features of complex mapping?
How to use pmcmd utility command?
What is the surrogate key?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Enlist the advantages of informatica.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the benefit of session partitioning?
What are the components of Informatica? And what is the purpose of each?
How can you generate reports in informatica?