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 |
How you can differentiate between connected lookup and unconnected lookup?
How to elaborate powercenter integration service?
Why should we use star schema in datawarehouse design?
Can you start a batches with in a batch?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
Write the program through which the records can be updated?
In Which scenario did u used Incremental loading?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
how can you load data into target table without leading zeor's