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 |
Differentiate between mapping parameter and mapping variable?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
What is difference between partioning of relatonal target and partitioning of file targets?
What is incremental aggregation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is difference between a connected look up and unconnected look up?
What are the two modes of datamovement in informatica sever?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
How you can differentiate between connected lookup and unconnected lookup?