1. HOW CAN YOU RECOGNIZE WHETHER OR NOT THE NEWLY ADDED ROWS IN THE SOURCE ARE GETS INSERT IN THE TARGET?
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range.
2. WHAT IS THE DIFFERENCE BETWEEN INFORMATICA 7.0 AND 8.0?
The basic diff b/w in between informatica 8.0 and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage concept
3. PERFORMANCE TUNING IN INFORMATICA?
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performa
4. DIFFERENCES BETWEEN NORMALIZER AND NORMALIZER TRANSFORMATION.
Normalizer: It is a transormation mainly using for cobol sources, it's change the rows into coloums and columns into rows Normalization:To remove the retundancy and inconsitecy
5. WHAT IS THE TARGET LOAD ORDER?
You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica ser
6. DIFF BETWEEN STATIC AND DYNAMIC CACHE? AND PLEASE EXPLAIN WITH ONE EXAMPLE?
Difference between static and dynamic cache- Static- Once the data is cached , it will not change. example unconnected lookup uses static cache. Dynamic- The cache is updated as to reflect the upda
7. WHAT IS THE USE OF INCREMENTAL AGGREGATION? EXPLAIN ME IN BRIEF WITH AN EXAMPLE.
Its a session option. When the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incr
8. WHAT IS THE DIFFERENCE BETWEEN INFORMATICS 7X AND 8X AND WHAT IS LATEST VERSION?
Java Transformation available in the 8x version and it is not available in 7x version.
9. HOW DO WE DO UNIT TESTING IN INFORMATICA? HOW DO WE LOAD DATA IN INFORMATICA?
Unit testing are of two types 1. Quantitaive testing 2.Qualitative testing Steps. 1.First validate the mapping 2.Create session on themapping and then run workflow. Once the session
10. IS SORTER AN ACTIVE OR PASSIVE TRANSFORMATION? WHAT HAPPENS IF WE UNCHECK THE DISTINCT OPTION IN SORTER? WILL IT BE UNDER ACTIVE OR PASSIVE TRANSFORMATION?
Sorter is an active transformation. if you don't check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table.
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range.
2. WHAT IS THE DIFFERENCE BETWEEN INFORMATICA 7.0 AND 8.0?
The basic diff b/w in between informatica 8.0 and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage concept
3. PERFORMANCE TUNING IN INFORMATICA?
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performa
4. DIFFERENCES BETWEEN NORMALIZER AND NORMALIZER TRANSFORMATION.
Normalizer: It is a transormation mainly using for cobol sources, it's change the rows into coloums and columns into rows Normalization:To remove the retundancy and inconsitecy
5. WHAT IS THE TARGET LOAD ORDER?
You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica ser
6. DIFF BETWEEN STATIC AND DYNAMIC CACHE? AND PLEASE EXPLAIN WITH ONE EXAMPLE?
Difference between static and dynamic cache- Static- Once the data is cached , it will not change. example unconnected lookup uses static cache. Dynamic- The cache is updated as to reflect the upda
7. WHAT IS THE USE OF INCREMENTAL AGGREGATION? EXPLAIN ME IN BRIEF WITH AN EXAMPLE.
Its a session option. When the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incr
8. WHAT IS THE DIFFERENCE BETWEEN INFORMATICS 7X AND 8X AND WHAT IS LATEST VERSION?
Java Transformation available in the 8x version and it is not available in 7x version.
9. HOW DO WE DO UNIT TESTING IN INFORMATICA? HOW DO WE LOAD DATA IN INFORMATICA?
Unit testing are of two types 1. Quantitaive testing 2.Qualitative testing Steps. 1.First validate the mapping 2.Create session on themapping and then run workflow. Once the session
10. IS SORTER AN ACTIVE OR PASSIVE TRANSFORMATION? WHAT HAPPENS IF WE UNCHECK THE DISTINCT OPTION IN SORTER? WILL IT BE UNDER ACTIVE OR PASSIVE TRANSFORMATION?
Sorter is an active transformation. if you don't check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table.
More Questions & Answers :-
No comments:
Post a Comment