What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Write all files in one directory then use file repository concept (don’t forget to type source file type as indirect in the session).
Use union transformation to combine multiple input files into a single target.
Two tables from two different databases are there . both having same structure but different data . how to compare these two tables ?