what is the main advantage of unconnected lookup
Answers were Sorted based on User's Feedback
Answer / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
Is This Answer Correct ? | 15 Yes | 0 No |
What happens if the info. Server doesn't find the session parameter in the parameter file?
Does Facttable Normalized or Denormalized?
What is an aggregator transformation?
Why update strategy and union transformations are active?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is a configuration management?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
how to join the two flatfiles using the joiner t/r if there is no matching port?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com