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

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1647


Define joiner transformation?

811


What is the use of transformation?

775


What is mapping debugger?

758


differences between service based and product based?

1791


what is the -ve test case in your project.

2116


What is data movement mode in Informatica and difference between them?

861


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

858


What are multi-group transformations?

797


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

903


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1763


What is sq transformation?

858


Explain the mapping variable usage example in informatica

860


What is substr in informatica?

902


What are the new features of informatica 9.x in developer level?

778