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

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

Enlist the various types of transformations.

0 Answers  

What are Business Components in Informatica?

1 Answers  

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

In joiner, how to load Master table in Target?

2 Answers  

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

What are parallel querys and query hints?

1 Answers  

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

Explain how many types of dimensions are available in informatica?

0 Answers  

how i will stop my workflow after 10 errors

2 Answers   HP,

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories