In target table how to display the system time



In target table how to display the system time..

Answer / murali

Add extr output port in expr trans for using sysdate
function.

Thanks,
Murali

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Informatica Interview Questions

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  


What is the difference between view and materialised view?

4 Answers  


My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,


Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,


how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,






How can you differentiate between powercenter and power map?

0 Answers  


How will u find weather dimension table is big in size of a fact table?

1 Answers  


Why do you use Mapping Parameter and mapping variable?

0 Answers  


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


What is powercenter on grid?

0 Answers  


Categories