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 is informatica etl tool?
What are the various types of transformation?
What are batches?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
How are indexes created after completing the load process?
Differentiate between source qualifier and filter transformation?
Which transformation should u need while using the cobol sources as source defintions?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
What are the different types of Type2 dimension maping?
Where do we use mapping variables in informatica?
Where are the source flat files kept before running the session?
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?