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 to get the first row without using rank t/r?

Answer Posted / abhishek kumar

step 1
if first row h as not null then we can use first()
function in aggregator T/F.

step 2
use sequence generator T/F And filter T/F write condition
nextval=1

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is standalone command task?

1319


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1273


What is InformaticaPowerCenter?

1138


What are the reusable transformations?

1166


What will be the approach?

986


What is a joiner transformation and why it is an active one?

1084


How can we use batches?

1026


What is depict expression change?

1125


Explain in detail about scd type 1 through mapping.

1555


can u give example for factless fact table

6655


how to load dimension table and fact table. plz tell me the steps.

2094


Can we get 1st record through Informatica(without sequence number).

1479


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160


What is meant by query override?

1061


What is the reusable transformation?

1048