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

Define joiner transformation?

811


What is decode in static cache?

804


What are the differences between a connected lookup and unconnected lookup?

837


Explain the shared cache and re-cache?

830


What is joiner transformation?

759


What is informatica powercenter repository?

926


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1895


How you know when to use a static cache and dynamic cache in lookup transformation?

1566


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

825


What are different types of transformations available in informatica?

757


Performance tuning in UNIX for informatica mappings?

2342


What all join we can perform in LOOKUP transformation?

758


What is powercenter on grid?

942


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4510


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10452