Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

without using rank transformation how can we rank items by
using some other transformations

Question Posted / shareenreddy

Answers were Sorted based on User's Feedback



without using rank transformation how can we rank items by using some other transformations..

Answer / sukanta

how your rank will look like

let suppose
ename sal
a 1000
b 1000
c 2000
d 1000
e 2000
and rank will work upon sal column.

what will be your target as per informatica rank works

ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 4
d 2000 5

if your rank will like this

ename sal rank
a 1000 1
b 1000 2
d 1000 3
c 2000 4
d 2000 5
or

ename sal rank
a 1000 1
b 1000 1
d 1000 1
c 2000 2
d 2000 2

all are can be done by using expression
transformation,sorter and aggrerator transformation combined
in a mapping.

Regards

Sukanta

Is This Answer Correct ?    5 Yes 3 No

without using rank transformation how can we rank items by using some other transformations..

Answer / bhupal

Use sorter t/r first and sort the data by using which port
u want

next use that expression t/r to generate the sequence by
using variable port

next u can use the filter t/r to restrict the data or
required ranks as a output.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

What are partitions in informatica and which one is used for better performance?

2 Answers  

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

can you please explain me pre session and post session options?

3 Answers   BTBP,

How to display First letter of Names in Caps?

7 Answers  

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

What is informatica?

0 Answers  

What is hash partition?

2 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

For more Informatica Interview Questions Click Here
Categories