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
Why update strategy and union transformations are active?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain lookup transformation is active in informatica
What is a joiner transformation and why it is an active one?
What is a node in Informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is event and what are the tasks related to it?
Explain the etl program with few examples.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain the types of transformations?
Is it possible to revert a global repository to local one and why?
Differentiate between Load Manager and DTM?
Explain lookup transformation in informatica
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)
Differentiate between reusable transformation and mapplet.