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
- 10855 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pooja
CREATE TABLE B
AS
SELECT *
FROM
(SELECT *
FROM
(SELECT *,ROWNUM R
FROM A)
ORDER BY R DESC)
WHERE R=1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
Does an informatica transformation support only aggregate expressions?
What are the components of workflow manager?
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What does “tail –f” command do and what is its use as an Informatica admin.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is Session and Batches?
What are the tasks that can be performed using sq?
What are batches?
When do you use sql override in a lookup transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What is union transformation?
can we override a native sql query within informatica? Where do we do it?
