Dynamic outputfilename

[Premium1980]

In Informatica I would like to create a dynamic outputfile. I got one source file and I want to create from that file more than one outputfile. Example:

Source:
A,12
A,2
B,1
C,1
C,2

Output to 3 files. A.txt B.txt and C.txt. The Name of each outputfile is dynamic to a value in the source.

Does someone know how to make this work?

In this example I have to create 3 outputfiles, in my case it's around 600 outputfiles.

Does someone know how to make this happen?

Greets
Jeroen

 

[naguch]

If you know the solution for this query. Please passit to us.
We are also facing same issue.

Thanks,
NageswaraRao.

 

[ArtieChoke]

No way I know of. You have to have the targets in the maps.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[blom0344]

Probably more succes to be achieved by a post-session that fires a stored procedure that loops through the data in the target and performs exports. May depend on your RDBMS if this is possible. What database do you use for targets?


Ties Blom

 

[naguch]

WE have an Oracle table that needs to be split into flat files.Not very conversant with stored procedures though.

 

[blom0344]

There is no problem if you have a limited (and fixed) set of flatfiles as desirable output. Simply use a router to distribute to seperate targets.
Obviously this will not be practical with 600 flatfiles as output / dynamically changing number of flatfiles.
That is why I was suggesting to have a look at an Oracle stored procedure (PL/SQL) to loop through the data. (and export set for set)

Ties Blom

 

[naguch]

Thanks, Ties Blom.
Are you written any stored procedure for the same.
If you have the SP, Please send to my id naguch@yahho.com

 

[blom0344]

naguch,

I do not have the need to write to such large sets of outputfiles. I was merely suggesting to try and use an alternative solution that complements the ETL-tool (as I definetely do not see an option to tackle this with Informatica)

Ties Blom