Excel File Target From Custom Query

Excel File Target From Custom Query

Posted in the Informatica Forum

CoolGuy

Richmond Hill, Canada

#1 Apr 29, 2013
Hi everyone,

I just pick it up because it is required in my work, anyways lets cut the crap.

I have a mapping with a source and source qualifier, in the SQ have a query which is retrieving column 1(code), column 2 (Week), column 3(Begin Date),column 4 (End Date), column 5(amount). The problem is that columns 2, 3 and 4 are customized values or hardcoded like a string, they don't come from the specific source because that is how I need to retrieve the results, in my Query I have 5 UNIONS and I am grouping by the column 1, 3 and 5.

First and last question.
Does anybody have any Idea how to put it on a CSV Excel Target File?



Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul 15 ann_p 2
active and passive t/f Jul 15 ann_p 2
Loading a specific Erwin model version into Met... Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records Feb '16 beginer_informatica 1
First and last rec from flat file to table Feb '16 Nan 1
More from around the web