Generate 4 different table structre records into single File

[e1994264]

Hi,
I have a requiremnt. I need to merge 2 different table structres into single file with Rec_Types.

Example:
i have 2 source tables in Oracle database.
1. EMP Tables(empno,ename,email,phone..)
2.Dept Table(Empno,dname,Location Col's)
I need to genrate the following sample output format:

Header|empno|ename|manager_id|email|phone
TraILER|empno|dname|location

[ray.wurlod]

Use the Column Export stage to generate common format, then Funnel stage to bring them together.