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
- 9705 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
How you prepared reports for OLAP?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between router and filter transformation?
What is meant by a domain?
What are the tasks that source qualifier perform?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
What happens when a session fails and you click on recover?
Briefly define a session task?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the format of informatica objects in a repository?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the various types of transformations.
