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

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  


What is DR strategy for Informatica project?

0 Answers  


Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,


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  


what is the difference between lookupoveride and joiner?

3 Answers  






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

4 Answers   TetraSoft,


we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,


why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,


get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,


What is the functionality of update strategy?

2 Answers  


Categories