how to load multiple files into one file using informatica

Question

I am new to informatics, I have created a mapping that using expression and sorter transformation to load multiple files into one single file which have 2 columns

1 data
2 seq number

All 10 files have random sequence numbers Like example: file1

erfef 3
abcdn 1

file 2

wewewr 4
wderfv 5

and so on till 10 files.

Expression transformation code is :

INTEGER(LTRIM(RTRIM(seq_num)),TRUE)

what I want is to load the file into one big file and sort it according to the seq number.

Got data in output file but number with incorrect seq number.

How to get data in the final table with a correct sequence number.

doing exactly what is mention in the below solution but still getting wrong output. getting output like:

erfef 3
abcdn 1                                                                                                                                            
wewewr 4
wderfv 5

where as it should be like below:

                                                                       where as it should be like 

abcdn 1                                                                                                                                
erfef  3                                                                                                                          
wewewr 4  
wderfv 5

Thanks in Advance !!!

Answer 1

Using indirect file source is one way.

Another way is to use command as source and specify a command that will spit out data from all the files, like cat file*.csv.

Just change the Input Type to Command and provide the command - all this can be set by editing session -> mapping tab -> Source -> properties.

Here's an example session: