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 / koti

take sequence generator to target and take expr
transformation to source qualifiew transf. and one new
port. and define that port as iif(sno=1 or 5,'true','false')
connect these to target.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active?

592


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2135


Explain lookup transformation is active in informatica

662


What is a joiner transformation and why it is an active one?

578


What is a node in Informatica?

619






what are the different types of transformation available in informatica. And what are the mostly used ones among them?

535


What is event and what are the tasks related to it?

614


Explain the etl program with few examples.

548


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1656


Explain the types of transformations?

596


Is it possible to revert a global repository to local one and why?

613


Differentiate between Load Manager and DTM?

1663


Explain lookup transformation in informatica

646


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1077


Differentiate between reusable transformation and mapplet.

572