empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
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 |
What are the different caches used in informatica?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
What is difference between a gateway node and worker node?
Define filter transformation?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
What are the different types of repositories created using informatica?
How can you access the remote source into your session?
can we use cartesian join in informatica
How many mapplets u have created? and what is the logic used
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
How to load only the first and last record of a flat file into the target?
If informatica has its scheduler why using third party scheduler?