CODEWITHSUNDEEP
informatica
Pranal
Pranal

Reputation: 13

Loading only 2 records from file into target table for every run using Informatica

I have a source file which contains 10 records. It doesn't has any primary key. Requirement is to load first two records at first run into target table. And then delete those records from source file. Now the source file will have 8 records. In next run, first 2 records will get loaded into target followed by getting deleted from source file.. How can I achieve this in Informatica Power centre

Upvotes: 0

Views: 388

Answers (2)

vanandsh
vanandsh

Reputation: 92

Source -> Sequence Generator -> Router(Group1 - Seq <=2 || Group 2 - Seq >2 )

You can now have two write components connected to each group of the router. 1st write component would be the target file and the other would be your source file where append if exists property is not enabled.

Upvotes: 0

Samik
Samik

Reputation: 3455

Use a sequence generator and a filter transformation to load only first two records. For deleting those records use scripts.

Upvotes: 0

Related Questions