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 |
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is DR strategy for Informatica project?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
what is the difference between lookupoveride and joiner?
how remove 1st 3 records & last 3 records in informatics
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
why sequence generator should not directly connected to joiner transformation ?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Performance tuning( what you did in performance tuning)
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What is the functionality of update strategy?