If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?

Answer Posted / reena

use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)

Is This Answer Correct ?    14 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is size of u r database?

1844


What are the settings that you use to configure the joiner transformation?

612


Clarify the utilization of aggregator cache record?

575


What are the measure objects?

659


On which transformations you created partitions in your project?

760






Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1846


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

620


without table how to come first record only in oracle?

1847


Explain about Informatica server process that how it works relates to mapping variables?

619


permutations of mapplet

2038


In development project what is the process to follow for an etl developer from day1

1278


Explain the tuning lookup transformation - informatica

608


What are the types of caches in lookup?

565


What is a filter transformation?

564


What is mapplet in informatica?

591