following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
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 |
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What are the joiner caches?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
How can repository reports be accessed without sql or other transformations?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are conformed dimensions?
In real time scenario where can we use mapping parameters and variables?
explain about informatica server architecture?