what are the difference between Informatica 7.1 and 8.1?
Answer Posted / maruzthi
IN BRIEF MAIN DIFFERENCES ARE
1.)PUSHDOWN OPTIMIZATION
(HERE YOU CAN PUSH TRANS LOGIC TO BE DONE IN THE SOURCE
OR TARGET DATABASE,SO THAT WE CAN PREVENT THE DATA TO CAME
OUT OF THE D.B LOGS)
2.)USER DEFINED FUNCTIONS LIKE
I.)REGULAR EXPRESSION.
II.)FINANCIAL.
III.)ENCODING
SUCH FN ARE OF TWO TYPES
1.)PRIVATE-ONLY CALLABLE FROM OTHER USER-DEFINDED FN
2.)PUBLIC-CALLABLE FROM ANY OTHER TRANSFORMATIONS FN.
F.F ENHANCEMENTS-OPTIONS FOR MERGING TARGETT PARTIONS
3.)IMP-INF-8 IS A SUBJECT -
ORIE`````````````````````````````````````````````````````1
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What if the source is a flat-file?
can u give example for factless fact table
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the tuning techniques you applied during your last project
What are the data movement modes in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Separate from an archive server and a powerhouse?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what are the Methods For Creating Reusable Transformations?
How can we use batches?
what is the size of u r source(like file or table)?
What are the popular informatica products?
what is SDLC way of code development?
Describe expression transformation?