1 - 1 of 1 Comments Last updated Apr 29, 2013

Irvine, CA

#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: (Registration is not required)

Add to my Tracker Send me an email

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
Is there a way to see a detail of the last run ... Aug 26 Jack 1
informatica Aug 13 swetha 1
Informatica 9 certification dumps (Dec '12) Jul '14 Rahul 22
informatica May '14 simson 1
Informatica services start and stop May '14 Tanguturi 1
Power center -DVO question (Sep '13) May '14 David Otte 2
Error while installing informatica Apr '14 krishna 1
Enter and win $5000

Informatica People Search

Addresses and phone numbers for FREE