How to list Top 10 salary, without using Rank Transmission?

Answer Posted / krishnakanth

I hope the simpliest way is what Raka #4 suggested
We can override in the SQL override in the source qualifier
transformation.

Is This Answer Correct ?    3 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2298


How do you load only null records into target? Explain through mapping flow.

1508


What are some examples of informatica etl programs?

537


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1630


Explain the scenario which compels informatica server to reject files?

657






Briefly define reusable transformation?

624


Can you use flat files in Mapplets.

2224


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

556


Can u generate reports in Informatica?

658


How do you use reject loader.

2071


How can repository reports be accessed without sql or other transformations?

729


In informatica workflow manager, how many repositories can be created?

782


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1917


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1690


Quickly characterize reusable change?

692