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

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

What are the different threads in DTM process?

2 Answers  

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

Explain about perform recovery?

1 Answers  

Differentiate between sessions and batches?

0 Answers  

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

How to implement security measures using repository manager?

0 Answers  

For more Informatica Interview Questions Click Here
Categories