This content has been marked as final.
Show 2 replies
-
1. Re: Order of data loaded/processed by informatica
EC140656 Sep 21, 2018 12:01 AM (in response to inuser492670)Hi Uma,
As per my knowledge, Informatica will load the data in the default order in which it found in the input file unless you use a primary key/surrogate key in your mapping.
If the order of rows getting loaded in the table is getting jumbled even though you don't use any key, I suggest the following :
Option 1 :
Add a sequence generator in your mapping which generates a sequence number for the dataset. Add the sequence number along with the dataset while loading into the target table.
Option 2:
Create a surrogate key in your target table to insert/maintain the rows in the same order as present in the source flat file.
Regards
Krishna
-
2. Re: Order of data loaded/processed by informatica
inuser492670 Sep 21, 2018 7:01 AM (in response to EC140656)Hi Krishna, Thank you.