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

in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?

Answer Posted / pavana

You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2055


How to create the source and target database connections in server manager?

1131


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1988


r u done any partitions in ur project?

1863


What are the components of Informatica? And what is the purpose of each?

1108


Explain sessions and how many types of sessions are there?

1058


what is mean by complex business rule ?

2218


hi real timers . iam waiting for ur reply regarding ETL TESTING

2312


What is the use of source qualifier?

1185


How many input parameters can exist in an unconnected lookup?

1602


Mention few power centre client applications with their basic purpose?

1002


What is joiner change?

1192


What is dynamic cache?

1085


Explain the use of aggregator cache file?

1317


Explain the features of connected and unconnected lookup.

975