↳
Left outer join inner join
↳
Unique, First and ALL Joins
↳
Talent Open studio is open source where where as enterprise version is not free
↳
If the job is related to data migration then bypass database log, Use tfilterrows, Use specific JVM arguments as per requirement Moins
↳
delete used to delete specific data, we can use with the where clause, delete can rollback the changes, delete the tabe row before deleting the row truncate used to delete entire data of the table, trucante can not used with where clause, truncate can't be rollback the changes, it is locks entire table Drop command is used to remove table definition & it's contents, drop command table space is free from memory,drop command viewof the table doesnot exits Moins
↳
tMap accepts more than one input one is main and rest of lookups. tJoin accepts only two inputs and only one is main and other one is lookup. Moins
↳
Use the rowid pseudocolumn. DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); Moins