Interested to Buy Any Domain ? << Click Here >> for more details...
empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
- 3 Answers
- 6661 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
In rank t/r select properties tab
select top and number of ranks is 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ganesh
write a query like
select * from <table_name> order by where sal=(select max(sal) from <table_name>)
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ,ike
well as per my knowledge
sc-->sq-->rank t/r-->target
In the rank transformation need to check rank port of sal
and group by empno.
correct me if i was wrong
| Is This Answer Correct ? | 0 Yes | 3 No |
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Define sessions in informatica etl?
Which transformation should u need while using the cobol sources as source defintions?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Can anyone please distinguish what is Inner join and Outer join
What is a router transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
can u any challenge your project?
what is difference between mapping and mapplet ?
Teradata 
