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
- 5765 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to do the error handling of if ur source is flatfiles?
Could you explain what is enterprise data warehouse?
What is the use of an aggregator cache file?
What are the different types of repositories created using informatica?
Describe expression transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is the reusable transformation?
What are the tasks that can be performed using sq?
Separate from a database, an information bazaar, and an information stockroom?
what are factless facts? And in which scenario will you use such kinds of fact tables.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Did u used latest transformations of 8.6.0? for what?
Explain your project of banking domian.
How an expression transformation differs from aggregator transformation?
What is option by which we can run all the sessions in a batch simultaneously?
