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 / 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
How to handle decimal places while importing a flatfile into informatica?
What is powercenter on grid?
What are the different options available for update strategy?
How many ways are there to create ports?
Explain the types of lookup transformation?
Slowly changing dimensions, types and where will you use them
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is an Integration service in Informatica?
expain about the tune parameters?
What is the benefit of partitioning a session?
What is informatica worklet?
Explain the use of aggregator cache file?
What are the modules in Power Center
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the types of schemas we have in data warehouse and what are the difference between them?