Source is the database. Target is a single excel sheet.
Have several queries, in that my first query result should be in excel sheet first tab and my second query result should be in excel sheet second tab and so on.
Here all the 3 results should be in a single excel sheet separated by tabs.
Can we implement this using sequential file? Is there any other stage supports this feature?
or else is this possible in unix so that will use the command in after job subroutine.
As far as I know, that may only possible using the Unstructured Data stage which is not available in your version. That's a job for a BI / Reporting tool, not ETL.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I thought about that but for some reason while knowing it could read from multiple worksheets / tabs, thought there were issues with writing to multiple worksheets. I guess we'll see!
-craig
"You can never have too many knives" -- Logan Nine Fingers