Interested to Buy Any Domain ? << Click Here >> for more details...
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..?
- 6 Answers
- 15788 Views
- I also Faced
- E-Mail Answers
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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
According to his methodology what all you need before you build a datawarehouse
How to create Target definition for flat files?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to Create a folder using pmrep command?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the mapping parameters and mapping variables?
What is the function of aggregator transformation?
Why is sorter an active transformation?
How to join three sources using joiner? Explain though mapping flow.
COM components can be used in Informatica
Why do we need informatica?
What are the designer tools for creating transformations?
What is rank index in rank transformation?
What is informatica? Why do we need it?
