Subir Member

Comments

  • 1.Add your datasets 2.Trans1-you can create a procedure in transformation with no output file Create Procedure AddIndexes Begin --add indexes in the below sample, wherever you required joins with other table. ALTER TABLE t1 ADD INDEX('t1.COLUMN') ALTER TABLE t2 ADD iNDEX(t2.COLUMN) End 3. Trans2-- Call the SP, like…
    in Creating indexes in mysql data flows Comment by Subir March 2017
Default Avatar