If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?

Answer Posted / venkateshmalneni

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by pre and post session shell command?

610


how to load dimension table and fact table. plz tell me the steps.

1675


What is main use of mapplet?

646


Briefly define a session task?

582


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

524






How can we improve session performance in aggregator transformation?

662


What does “tail –f” command do and what is its use as an Informatica admin.

622


Explain about cumulative Sum or moving sum?

613


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

771


How to use procedural logic inside infromatica?

626


can anyone explain me about retail domain project in informatica?

7415


What is rank transformation in informatica

680


What is meant by a domain?

616


How to create Target definition for flat files?

743


What is meant by incremental aggregation?

571