Excel File Target From Custom Query
Posted in the Informatica Forum
Richmond Hill, Canada
#1 Apr 29, 2013
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?
Add your comments below
|Informatica Admin & Cloud Deployment (May '17)||May '17||avi_infa||1|
|Converting row data to column data (Sep '16)||Sep '16||Roopa||1|
|How to Handle Horizontal tab in Flat file in in... (Sep '15)||Jul '16||ann_p||2|
|active and passive t/f (Feb '16)||Jul '16||ann_p||2|
|Loading a specific Erwin model version into Met... (Apr '16)||Apr '16||SCHJA26||1|
|not recognizing the source file (Jun '08)||Mar '16||Jayashree||2|
|calling informatica powercentre workflow as a s... (Mar '16)||Mar '16||anil||1|
Find what you want!
Search Informatica Forum Now
Copyright © 2018 Topix LLC