i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.

Answer Posted / rajasekhar

Better to take Sequence generator t/r. initial value 0 and
current value is 1 and increment by 4 . It is suitable for
ur query

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if we have a delimiters at unwanted places in a flat file how can we over come those.

1570


What are the different types of transformation available in informatica.

635


What are batches?

619


How can we handle two sessions in informatica?

613


What is lookup transformation?

595






Enlist the various types of transformations.

557


What is the use of target designer?

608


how to create user defined function (udf) in informatica

783


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

603


what is the hint? how to use it to reduce the query processing in program?

6300


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

722


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What are the informatica performance improvement tips

615


What is the format of informatica objects in a repository?

599


what is diff b/t sorter t/r and agg have the option sorter property...

1746