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...


how the informatica server sorts the strings values in rank
transformations?

Answers were Sorted based on User's Feedback



how the informatica server sorts the strings values in rank transformations?..

Answer / amit kumar

When the Integration Service runs in the ASCII data
movement mode, it sorts session data using a binary sort
order.
When the Integration Service runs in Unicode data movement
mode, the Integration Service uses the sort order
configured for the session. You select the session sort
order in the session properties. The session properties
lists all available sort orders based on the code page used
by the Integration Service.
For example, you have a Rank transformation configured to
return the top three values of a string port. When you
configure the workflow, you select the Integration Service
on which you want the workflow to run. The session
properties display all sort orders associated with the code
page of the selected Integration Service, such as French,
German, and Binary. If you configure the session to use a
binary sort order, the Integration Service calculates the
binary value of each string, and returns the three rows
with the highest binary values for the string.

Is This Answer Correct ?    6 Yes 2 No

how the informatica server sorts the strings values in rank transformations?..

Answer / pavan

IN RANK T/F PROPERTIES THERE IS AN OPTION "CASE SENSITIVE STRING COMPARISION " U CHEK THIS OPTION THE INTEGRATION SERVER SORTS THE STRING VALUES

Is This Answer Correct ?    1 Yes 1 No

how the informatica server sorts the strings values in rank transformations?..

Answer / kiran

Binary sort order

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is Cognos script editor?

0 Answers   Cognizant,


what is casual dimension?

6 Answers   IBM,


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


When will you use SQL override in a lookup transformation?

1 Answers  


What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,


What is the capacity of power cube?

1 Answers  


Explain the aggregator transformation?

0 Answers  


what is dimension table?

17 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


Categories