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

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

623


What are the static cache and dynamic cache in informatica?

712


How is union transformation utilized?

567


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1869


What are the advantages of using informatica as an etl tool over teradata?

567






What is a snowflake schema?

569


How to create Target definition for flat files?

752


Which development components of informatica have the highest usage?

593


What is sorter transformation?

582


Explain in detail scd type 2 through mapping.

611


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


What is session task and command task?

647


Is it possible to create multiple domains on a single Informatica server?

751


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

549


How do you load only null records into target?

742