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 |
How does a rank transform differ from aggregator transform functions max and min?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
How to import oracle sequence into Informatica?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Kimball and Inmon methodologies?
Target increases every day even though no new record was inserted
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
how we can do session partition in informatica any one explain me clearly? thanks advance.
How do you load only null records into target? Explain through mapping flow.
In real time scenario where can we use mapping parameters and variables?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.