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
- 10651 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
What is the scenario which compels informatica server to reject files?
What are the guidelines to be followed while using union transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is the hint? how to use it to reduce the query processing in program?
What is Session and Batches?
What is rank index in rank transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Explain lookup transformation source types in informatica
Why union transformation is an active transformation?
What are connected or unconnected transformations?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to load a Dimension ? and how to load a fact table?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are the basic requirements to join two sources in a source qualifier transformation using default join?
