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

Answer Posted / etl guru

not possible first & last function in aggregator

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

892


what is the Default Source Option For Update Strategy Transformation?

969


What does role playing dimension mean?

798


Design a mapping to load the cumulative sum of salaries of employees into target table?

1178


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1907


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1813


What is deployment group?

882


What is status code in informatica?

783


How to elaborate powercenter integration service?

869


What is depict expression change?

802


What is substr in informatica?

892


What does command task mean?

801


Performance tuning( what you did in performance tuning)

1709


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1401


When do you use sql override in a lookup transformation?

776