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
- 6471 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
Mention some types of transformation?
What could be the possible resons of locks by user?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a standalone command task?
Which is the t/r that builts only single cache memory?
Is it possible to create multiple domains on a single Informatica server?
What is domain and gateway node?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is repository manager?
How to convert multiple rows to single row (multiple columns) in informatica
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain what is informatica metadata and where is it stored?
What is a repository manager?
How to do unit testing in informatica?
