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
select * from (select rownum as num,a.* from A a) where num=(select count(*) from A);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
What is a router transformation?
How can we delete duplicate rows from flat files?
Can you use flat files in Mapplets.
Whats there in global repository
What is target load order?
Performance tuning in UNIX for informatica mappings?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a repository? And how to add it in an informatica client?
What is incremental aggregation?
What is a repository manager?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What does reusable transformation mean?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is sq transformation?