@bmdirshad,
I think you didnot go thr my query properly.I want the rank to be displayed in the query.
Otherwise what you have mentioned would be correct.
Regards
Tanya
Type: Posts; User: tanya_j; Keyword(s):
@bmdirshad,
I think you didnot go thr my query properly.I want the rank to be displayed in the query.
Otherwise what you have mentioned would be correct.
Regards
Tanya
Hi Divya,
Thanks for the suggestion.But Im using Oracle database
The answer for the query is as follows:
This can be done using a self join
SELECT A.ROLLNO,A.NAME,B.MARKS,RANK()OVER (ORDER BY...
Hi,
I would like to get training notes on Datawarehousing-Informatica
Regards
Tanya
Hi,
I am interested in the same.
Please provide me the details.
Regards
Tanya
Hi,
Suppose we have a table with fields
Rollno Name Marks
1 A 95
2 B 90
3 C 75
4 D 80
5 E 85
Write a query to display rollno,name,marks,Rank in ascending order of rank.
Hi,
If im not mistaken ur qn is
Src
1 A
1 B
1 C
2 G
2 H
2 I
If there is only one port to be returned then we can go for unconnected lookup transformation.
Consider two cases: 1. Power center server and client on the same machine 2. Power center sever and client on the different machines what is the basic difference in these two setups and which is...
Can we use an active transformation inside a mapplet?
In the update strategy, instead of using DD_INSERT I put the value as 1. Will this work?
My source data is a flat file and it has empid, deptid and 12 columns for salaries of each month (jan-dec).
Now my requirement is to create one record for each month and also running total of the...
How can you transpose rows to columns and vice versa and what transformations would you choose?
Pls explain how to do the mapping..
Can we use a flat file as a lookup?
Do a lookup on target table with its primary key.If row already exists then update else insert...This can be done using a router transformation and an update strategy transformation.
Look-up transformation just does look-up on the source,target table etc..Look-up is passive as it doesnot change the no.of rows passing through it.