when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.