write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009
i want the output
date
11-mar-2010
30-may-2010
Answer Posted / gyana
u can use the TODATE() function to make it as default date
and time
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
What is the use of an aggregator cache file?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to load the data from people soft hrm to people soft erm using informatica?
What does command task mean?
Explain joiner transformation in informatica
what is informatica metadata?
How to update source definition?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are session parameters ? How do you set them?
Scheduling properties,whats the default (sequential)
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
What is a repository? And how to add it in an informatica client?
What is different between the data warehouse and data mart?