In target table how to display the system time

Question Posted / raju

1 Answers
4746 Views
I also Faced
E-Mail Answers

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

Can i create a lookup table without cache.

7 Answers iGate,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers Wipro,

can we have to do changes in session property when we are dynamically generating target files?

3 Answers Wipro,

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers Informatica,

What are the basic needs to join two sources in a source qualifier?

3 Answers

What is a router transformation?

0 Answers

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers

How to implement security measures using repository manager?

0 Answers

Define the various join types of joiner transformation?

0 Answers

What is checksum termnology in informatica? Where do you use it ?