how to load only the first and last record of a flat file
into the target?

Answer Posted / tilak

use sequence generator , pass values only with max and min
sequence number filter to target

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the measure objects?

659


What are the static cache and dynamic cache in informatica?

709


Explain what is informatica metadata and where is it stored?

604


Define joiner transformation?

590


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4968






What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

632


Which version configuration tool used in ur project?

2762


Which are the different editions of informatica powercenter that are available?

553


What are roles and groups and benefits of using them?

569


Explain the types of transformations?

596


tell me the rules and responsblites in our project(my project is development)

1493


What is the surrogate key?

631


is it possible to index the data in cache of lkp transformation ?

1520


Explain why we use partitioning the session in informatica?

607


What is expression transformation?

629