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
- 1 Answers
- 4500 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vijaya
by using Deocde or case expression get the above o/p
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is source qualifier transformation in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is exclusive and normal mode for repository services?
What does update strategy mean, and what are the different option of it?
What are batches?
What are the static cache and dynamic cache in informatica?
Write the unconnected lookup syntax?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Mention a few design and development best practices for informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Different sorts of metadata that stores in the storage facility?
Explain sql transformation in script mode examples in informatica
