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



write sql query following table pname description lux soap sunsilk shampoo lux shamp..

Answer / vijaya

by using Deocde or case expression get the above o/p

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Informatica Interview Questions

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


How to elaborate powercenter integration service?

0 Answers  


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


Can you start a batches with in a batch?

1 Answers  


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?

6 Answers  






HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,


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.

5 Answers   DELL, TCS,


Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,


Write the program through which the records can be updated?

0 Answers  


In Which scenario did u used Incremental loading?

2 Answers  


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. 

1 Answers   Cipla, Quintiles,


how can you load data into target table without leading zeor's

4 Answers   Deloitte,


Categories