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
- 15988 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
Explain in detail about scd type 1 through mapping.
where to store informatica rejected data? How to extract the informatica rejected data?
what is the Default Source Option For Update Strategy Transformation?
What are roles and groups and benefits of using them?
server hot-ws270 is connect to Repository B. What does it mean?
Define the various join types of joiner transformation?
What is meant by target load plan?
what is song in infrmatica...?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
difference between repository database and repository service?
How are the sources and targets definitions imported in informatica designer?
What are the data movement modes in informatica?
Global and Local shortcuts. Advantages.
Enlist the tasks for which source qualifier transformation is used.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
