When we use the tMap function is allowed 100 rows at the time?

[Ashok200792]

When we use the tmap Function is allowed 100 rows in the one CSV file upload the data in the MySQL database on the particular table, when we use that table of one column is (int "Auto increment") column. How to solve this insert data in database, i have attached the sample screen shot.

We need to insert the All records into the database. 

[TRF]

@Ashok200792, this is not exactly the same case.
You have no rows in the input table so every records from the file are rejected by the inner join, catched on the output flow and inserted into the output db.
Also, you have only 99 records in the input file, not 145 as in the previous example.

[Ashok200792]

i don't know how to figure that , i try another file for example also

@sgv

I try that its return only 2 rows .

[Ashok200792]

mysql> select * from temp_salesorder_list\G
Empty set (0.24 sec)

(100 below OR equal 100 rows ) before we Lookup the database (We check monitored), check 0 rows return 

(100 rows )After we Lookup the database (We check monitored) ,check 1 rows return 

I share the before pictures return 1 rows from the Lookup (temp_salesorder_list) ,it database we never insert the exit data.

Empty set (0.24 sec) --- No data

[Ashok200792]

We used tMysqlinput everytime check the row in database(initially zero record in the table )
its allowed 100 rows after that every data is rejected,

After that 100 rows completed i will checked the row is database ,its not commit return ( Empty set (0.24 sec) --- No data)

can you explain why that other record or rejected ??

Any alternative solution for this?? can you guide me . we struck in couple of days .

[Ashok200792]

Its rejected , but in MySQL database Empty set (0.24 sec) --- No data in that table, but we get the 1 rows to check after 100 rows so its goes to rejected flow.

Can you guide me.

[Ashok200792]

Finally we get the solution for this topic , but i don't know how the data after 100 rows its goes rejected without commit the mysql , matching data from Mysql database we added in the query one more where condition to pass that time its working very fine .


Thanks for support team,

By
ASHOK M