Interested to Buy Any Domain ? << Click Here >> for more details...
i have thousand records in my source(flat file) i wanna load
990 records i don't want load first 5 records and last 5
records at informatica level?
- 3 Answers
- 9220 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
source--->source qualifier--->sequencegenerator--->
exp--->router--->target.
Take nextval port and assign to exp
In router write condition below as
nextval>=5 and nextval<=995
copy all the ports from router to target
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Enlist some properties of sessions.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the advantage of informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
In development project what is the process to follow for an etl developer from day1
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to update or delete the rows in a target, which do not have key fields?
can we override a native sql query within informatica? Where do we do it?
Explain how many types of dimensions are available in informatica?
What do you understand by a term domain?
What is meant by lookup transformation?
What do you mean incremental aggregation?
What are the different types of transformation available in informatica.
What is xml source qualifier transformation in informatica?
