In Transformer, joining two small table but preview does not show any output for join processor

Hi All,

in Transformer I’ve created a simple pipeline join 2 small MySQL table but join processor doesn’t show any output records, but previews show actual number of records to be saved in destination.
While doing the same things with MySQL in backend actual record count is matched what previewed record is showing.