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
- 10892 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / devi
CREATE TABLE B
AS
SELECT * FROM A
ORDER BY ROWNUM DESC;
| Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the modules in Power Center
Quickly characterize reusable change?
How to elaborate tracing level?
How many transformations can be used in mapplets.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How can a transformation be made reusable?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is rank transformation in informatica
How to extract sap data using informatica?
How can we create index after completion of load process?
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
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the use of an aggregator cache file?
