If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
Answer Posted / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
What is the use of code page?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Enterprise data warehouse your projects phase by phase explain?
What is flashback table ? Advance thanks
Explain sql transformation in script mode examples in informatica
What is the use of an aggregator cache file?
What happens when a session fails and you click on recover?
What is the benefit of partitioning a session?
What are the types of schemas we have in data warehouse and what are the difference between them?
how to load rows into fact table in data warehouse
What is a pre-defined event and user-defined event?
Design time, run time. If you don't create parameter what will happen
Write the unconnected lookup syntax and how to return more than one column.
How to Create a folder using pmrep command?