A mapping contains

(1) Source Table S_Time ( Start_Year, End_Year )

(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )



A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim (..

Answer / pati

Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,


How do you implement unconn. Stored proc. In a mapping?

1 Answers  


If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,






Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  


how to load duplicate row in a target

4 Answers  


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

0 Answers   CTS,


what type of transformation is not supported by mapplets?

4 Answers   CTS,


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


In informatics server which files are created during the session rums?

0 Answers  


Categories