Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
- 15 Answers
- 26582 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sujatha
Hi,
First declare mapping variable like $$rec_load in mapping tab under parameters/variables.
next in expression transformation declare one port like rec_count=setvariable($$rec_load,$$rec_load+1000)
first time $$rec_load having value zero.next time it will load 1000 records like that every run it will increment 1000 records.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
without table how to come first record only in oracle?
Quickly characterize reusable change?
EXL informatica Questions
How to create Target definition for flat files?
What is the sequence generator transformation in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
How does the aggregator transformation handle null values?
how we can load rejected record's at run time?(not through bad files)
where to store informatica rejected data? How to extract the informatica rejected data?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is a joiner transformation?
Mention some types of transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What is the use of code page?
