data not transferring from staging table to target table?

[manmathpanda]

Hi Developers,

There are almost 300000 records in staging table when i open the data source and click on load data it is showing almost 300000 above records and when i click on transform , it only transforms few records i.e some time 21 records and now in my database only 1200 records coming out of 300000. May i know the reason behind this.

Please suggest me what to do in this case?

Regards,

Manmath

[asifnoor]

1. First check the import log and see if there are any errors.

2. If no errors, then in transform map, check if you have selected any field as coalesc. If yes, then check your source data and see if they are matching or not.

[manmathpanda]

hi asif,

1) In import log, there is no issue.

2) i have selected colasce to email field. and in field maping all r correct.

Regards,

Manmath

[asifnoor]

1. Also in the import table, check if you have all the 300000 records present or not. 

2. are there any import scripts running?

3. while running transform, can you uncheck  BR and then run.

[asifnoor]

Did you check whether the import set table has all the mentioned records?