Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a scenario where I have two different set of continous csv files with different metadata for emp and dept files. The file names will be (emp_1.csvemp_2.csv..... emp_10.csv) and (dept_1.csv,dept_2.csv, dept_3.csv).Both the set of files are in same folder
Is it possible to process both the set of files using single tfilelist component or i should use two different flows with two tfilelist components each for emp and dept.
tfilelist -> tfileinputdelimited -> tmap -> tDBOutput ( is this correct to process both set of files)
Or is there any other way to achieve this.??
Could anyone reply asap?
Thanks,
Kiran Kumar
1)
after iterator link use dummy tJava and then two run if based on file name
2) use dynamic schema if there is no transformation before load.tDboutout change table name based on file name