Commit Interval

[kpmINFO]

Here is an issue I need some expert advise on it

I am trying to load data from a source file into a target database,
Before loading any data to the target I would like to load first record saying "Informatica Started" into my target.
Following that all the source rows.
And the last line in the database should be "Informatica Completed" .

to achieve this functionality, I am running three sessions, first session (Session1) to load just one record into the database saying "Informatica Started"

Second session (Session2) to load all source records into the database.

Third session (Session3) to load a record to the database saying "Informatica Completed"

in my work flow
session1 -> Session2 -> session3
this is the order.
In theory, first line in the database should "Informatica Started" following that rest of the lines should be my source rows and the last line should be "Informatica copmpleted"

But when I run the session this is not the order, first few lines are source records some where after 10 to 30 rows "Informatica Started" appears and the last line is not "Informatics Completed" this too appears in the in between source rows.
Can someone advise me why this behavior is, and what is the solution for this.

In my first and third session I made the target commit interval as 1, still the order is not what I wanted.

Can some advise me on this .

 

[sdap4321]

In your workflow
Configure the session 2 to start only after session 1 completes sucessfully and 3 after 2 ,while connecting the sessions(1,2,3) with link tasks

 

[ArtieChoke]

Also, you need to have some sort of key to maintain order. Physical insertion order only works occasionally, like when the table has only a few rows and is contained in a single page - you can't count on retrieving the table in that order.

"I think we're all Bozos on this bus!" - Firesign Theatre