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
|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|
Find what you want!
Search Informatica Forum Now
Copyright © 2016 Topix LLC