Interested to Buy Any Domain ? << Click Here >> for more details...
following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
- 2 Answers
- 5764 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti
by using expression transformation U can apply decode
function..
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / abhishek kumar
src->sq->exp->filter->tgt
expression t/f
flag ->
iif(gender='male','female','male')
abhishek guddu
| Is This Answer Correct ? | 7 Yes | 2 No |
What is the difference between OLTP and ODS?
what is row level and column level indicator?
What are the associated ports in look up T/R.
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
What is confirmed dimension with scenario
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a filter transformation and why it is an active one?
How to open an older version of an object in the workspace?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
How to load the data from people soft hrm to people soft erm using informatica?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
Teradata 
