following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answer Posted / koti
by using expression transformation U can apply decode
function..
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
if we have a delimiters at unwanted places in a flat file how can we over come those.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the steps involved in the migration from older version to newer version of Informatica Server?
pmscmd startworkflow -sv
What is workflow? What are the components of the workflow manager?
generate date / time dimension in informatica
How is union transformation utilized?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is confirmed fact in dataware housing?
What are batches?
Explain the informatica workflow?
What are the popular informatica products?
Explain the different kinds of facts.