If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / imran
use a Sequence Generator T/R........
GO to SG T/r-->Properties (Set the values as shown below)--->
1) 'Enable' the Cycle Option
2) give 'Start value' as 50
3)End Vale 100
4) Increment BY 1
5) Connect Nextval & Currval o/p ports to Target
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
where to store informatica rejected data? How to extract the informatica rejected data?
How to do unit testing in informatica? How to load data in informatica ?
How can you validate all mappings in the repository simultaneously?
What is the need of an ETL tool?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Why do we need informatica?
What is parallel processing in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain sql transformation in script mode examples in informatica
What are the tuning techniques you applied during your last project
What is domain and gateway node?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Differentiate between a database and data warehouse?