In target table how to display the system time

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

633


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7693


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

642


Can u generate reports in Informatica?

663


What is decode in informatica?

669






how many types of dimensions are available in informatica?

572


I have a flat file, want to reverse the contents of the flat file

708


What is blocking transformation?

726


How to open an older version of an object in the workspace?

632


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

711


How many transformations can be used in mapplets.

1470


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

750


Whats there in global repository

1278


Explain lookup transformation source types in informatica

709


What is the benefit of session partitioning?

612