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
- 6578 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 static cache and dynamic cache in informatica?
What are the types of caches in lookup? Explain them.
How is union transformation utilized?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the difference between writing a joiner query in ANSI style and THETA style?
How many dimensions are there in informatica?
What is InformaticaPowerCenter?
What is the Process to creating lookup transformation in informatica
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How would you join a node to the already existing domain?
How to go to the older version for a mapping?
Which files are created during the session rums by informatics server?
What is joiner transformation in informatica?
Explain the difference between a data warehouse and a data mart?
What are the new features of informatica 9.x in developer level?
