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

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  


How to import oracle sequence into Informatica?

3 Answers   Satyam,


In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  






Kimball and Inmon methodologies?

2 Answers  


Target increases every day even though no new record was inserted

0 Answers   Accenture,


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,


How do you load only null records into target? Explain through mapping flow.

0 Answers  


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  


Categories