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 |
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?
What is the difference between view and materialised view?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
how remove 1st 3 records & last 3 records in informatics
How can you differentiate between powercenter and power map?
How will u find weather dimension table is big in size of a fact table?
Why do you use Mapping Parameter and mapping variable?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What is the difference between SOURCE and TARGET BASED COMMITS?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is powercenter on grid?