Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

POPULATE TARGET COLUMN WITH CONSTANT

Status
Not open for further replies.
auma

auma

Technical User
May 23, 2003
1
IE
I need to populate one of the colums in my target with
a constant string. How will I do that.
EX: column on Depart_name in Department I want it to show
'ACCOUNTS'. 'ACCOUNTS' i want to display on all rows.
 
Sort by date Sort by votes
You can create a port in an Expression (set the port to be an output only) and hard code 'ACCOUNT'.

Hope this helps,

dinzana
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Conditional insert into a Target
Replies
1
Views
59
rasETL
rasETL
sa0309
  • Locked
  • Question
Source and Target Issue
Replies
0
Views
61
sa0309
sa0309
sa0309
  • Locked
  • Question
Router Output to a "Single Target Table"
Replies
1
Views
83
rasETL
rasETL
sa0309
  • Locked
  • Question
Informatica Target Table update 1
Replies
2
Views
76
sa0309
sa0309
newbie1314
  • Locked
  • Question
New to informatica, need help with expression transformations
Replies
0
Views
73
newbie1314
newbie1314

Part and Inventory Search

Sponsor

Back
Top