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

[Mukesh Sharma]

can you provide the screenshot for transform script and field maps ? can you check if you made some some field map as Colace as true . or in script , if you have writtern ignore=true ;

[manmathpanda]

Hi Mukesh,

I have only made email field as coalesce. and the field maps are correct and there is no script written.

Regards,

Manmath

[Varsha21]

Hi,

may i know your tar-gate table?

and which type of file you are trying to import?