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
- 6434 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari
create mapping like
source -- sorter -- expression -- filter -- target.
here sorter is used to send data by ascending order data
this is not mandatory.
Expression is need to create variable port which will count
the rows which are comming in.
Filter having condition like if count value >=51 and count
value <= 100.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the reusable transformations?
State the differences between sql override and lookup override?
waht type of interface is used for testing the data in informatica
Why sorter is an active transformation?
Explain the difference between a data warehouse and a data mart?
tell me the rules and responsblites in our project(my project is development)
How to extract sap data using informatica? What is abap? What are idocs?
what is $$$$?
What is data caches/ index caches?
What is rank transform?
Differentiate between a database and data warehouse?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is domain and gateway node?
What is Cognos script editor?
How you can differentiate between connected lookup and unconnected lookup?
