Interested to Buy Any Domain ? << Click Here >> for more details...
following table
source target
name gender name target
a1 male a1 female
a2 female a2 male
i want a1 female update to target how will do?
- 2 Answers
- 6012 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / kasi gaddam
Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as
IIF(gender=male,female,male)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What's the layout of parameter file (what does a parameter file contain?)?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How might you approve all mappings in the archive all the while?
Can we get 1st record through Informatica(without sequence number).
What is the difference between source qualifier transformations source filter to filter transformation?
Can we override a native sql query within informatica?
Define enterprise data warehousing?
Design a mapping to load a target table with the following values from the above source?
Is there any target staging area in informatica not staging area
What is a joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the difference between Active and Passive transformation?
What is the maplet?
What is rank transformation?
Mention few advantages of router transformation over filter transformation.
