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
- 11082 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / devi
CREATE TABLE B
AS
SELECT * FROM A
ORDER BY ROWNUM DESC;
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / priyank
In Informatica, make table A as Source and follow the below
mapping:
SRC_A --> AGG --> TGT_B
AGG: Do not check any of the columns for group by and pass
the output to target B. In this way, only the last row will
be passed through.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / upendra
In Informatica mapping we can find source A last record into Target B first record.
SRC-->Rank--> TGT
note:rank transformation edit propertities tab assign bottom=1
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / dilip ingole
by using with clause
WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / mr lee
Select * From Table A Where ROWID = (Select Max(ROWID) From
Table A
Union
Select * From Table B Where Rownum = 1
| Is This Answer Correct ? | 0 Yes | 1 No |
what is song in infrmatica...?
How can you validate all mappings in the repository simultaneously?
wt is Dynamic lookup Transformation? when we use?how we use?
What is the difference between stop and abort in informatica
HOW TO GET THE LATEST DATA IN SCD ?
how to calculate the optimum cache size in aggregator transformation?
What is the Rank index port in Rank transformation?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
Explain sessions and how many types of sessions are there?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Teradata 
