Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?
- 2 Answers
- 6581 Views
- I also Faced
- E-Mail Answers
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
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
waht type of interface is used for testing the data in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can you use flat files in Mapplets.
What are the different types of transformation available in informatica.
How do you change a non-reusable transformation to reusable transformation?
How do you convert single row from source into three rows into target?
How to open an older version of an object in the workspace?
Which transformation should we use to normalise the COBOL and relational sources?
Write the advantages of partitioning a session?
What are multi-group transformations?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Differentiate between router and filter transformation?
What happens when a session fails and you click on recover?
Explain lookup transformation is active in informatica
