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
- 6085 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 is sorter transformation?
Differentiate between reusable transformation and mapplet.
What are the tasks that can be performed using sq?
update strategy transformation in informatica
Enlist the tasks for which source qualifier transformation is used.
Briefly define a session task?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is complex mapping?
Why update strategy and union transformations are active? Explain with examples.
What is the maplet?
Enlist few areas or real-time situations where informatica is required.
Mention few advantages of router transformation over filter transformation.
What are pre and post-session shell commands?
Plz can any one say me how to get the informatica certification materials and dumps
