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
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Under which circumstances, informatica server creates reject files?
How to elaborate tracing level?
What are batches?
How to do the error handling of if ur source is flatfiles?
Global and Local shortcuts. Advantages.
How many types of sessions are there in informatica.please explain them?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is a predefined event?
what are the Methods For Creating Reusable Transformations?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to extract sap data using informatica? What is abap? What are idocs?
Explain the different lookup methods used in informatica?
Briefly define a session task?