I have requirement where i need to send mutliple files based on the data. Our enivroment is Unix and teradata.
EG: below is table with sample table.
Now i need fast export the files based up on ID and the file name should Name_ID.txt (Eg: Name_1.txt).
And Name_1.txt should have 1's Data only...
Please help me...
You are asking for a tool that will create the file name based on some criteria we do not see until we actually start exporting the data.
That is not usually how our tools work.
We need to know the name(s) of the files ahead of time.
Usually I used to change the files name at the end of fexp using the .SYSTEM cmd As our eniv us unix..
I have an Idea but dont know whether it works.
Storing all the Distinct Id's in a table and then for each id we need to filter the table data in the fast export then sending a file.
i am in a intial stage just tyring to implement ..