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 |
Explain load alternative records / rows into multiple targets - informatica
What happens if we dont select data driven option?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
why we use stored procedure transformation?
What is domain and gateway node?
HOW TO YOU LOAD TIME DIMENSION
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
how can we check whether a particular cache is static or dynamic?