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
- 9713 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
define galaxy repository in informatica
What is union transformation in informatica?
What is resilience time?
Enlist the differences between database and data warehouse.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
I have a flat file, want to reverse the contents of the flat file
Which version configuration tool used in ur project?
Does an informatica transformation support only aggregate expressions?
write a query to retrieve the latest records from the table sorted by version(scd)
How to partition the Session?
What is the maplet?
How to start a workflow using pmcmd command?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load only null records into target? Explain through mapping flow.
