Add extr output port in expr trans for using sysdate function. Thanks,

In target table how to display the system time

Question Posted / murali

1 Answers
4742 Views
I also Faced
E-Mail Answers

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

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2147

What is the sql query overwrite in source qualifier in informatica

1137

What is a sequence generator transformation?

1068

What is an active transformation?

1154

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

1110

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1956

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2441

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2351

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2066

What is lookup transformation?

1088

Slowly changing dimensions, types and where will you use them

1767

How to do unit testing in informatica? How to load data in informatica ?

1179

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2896

What is pmcmd command?

1176

Explain the types of lookup transformation?

1100