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

i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Answer Posted / vijay

Are you saying you want the first 7 records from the source
table?

If that is the case, write an override in source qualifier
and fetch by the row number. That would be the fastest
way.Load into target.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116


What are mapplets? How is it different from a Reusable Transformation?

1136


Can we change Dynamic to Static or Persistent cache? If so what happens?

2256


Explain pmcmd command usage in informatica

1189


Does an informatica transformation support only aggregate expressions?

1088


can we override a native sql query within informatica? Where do we do it?

1166


What is primary and backup node?

1174


How to differentiate between the active and passive transformations?

1230


What is the difference between informatics 7x and 8x and what is latest version?

1138


What are the different components of powercenter?

1114


complex mapping ur project u r invlve can u explain and give real time example give me ?

2351


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2303


what are the Methods For Creating Reusable Transformations?

1257


Is it possible to revert a global repository to local one and why?

1135


What is rank transformation?

1037