write sql query following table
pname description
lux soap
sunsilk shampoo
lux shampoo
sunsilk soap
clouseup soap
closeup paste
i want the output like
pname description
lux soap
sunsilk shampoo
lux soap
sunsilk shampoo
closeup paste
closeup paste
Answer / vijaya
by using Deocde or case expression get the above o/p
Is This Answer Correct ? | 6 Yes | 2 No |
What exactly mentioned in High level design document.can somebody explain me sequentialy.
how to import multiple flat files in to single target where there is no common column in the flat files
where to store informatica rejected data?
what is mean by flag 4 in update strategy t/r
How we will implement Pushdown Optimization and Types in Informatica with better examples
Can informatica load heterogeneous targets from heterogeneous sources?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
what is workflow varible
Implementation methodology
What is Session and Batches?
what is unit testing?tell me proceedure
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.