61. WHY DID YOU USE STORED PROCEDURE IN YOUR ETL APPLICATION?
Usage of stored procedure has the following advantages 1 checks the status of the target database 2 drops and recreates indexes 3 determines if enough space exists in the database 4 perfor
62. WHAT ARE THE DIFFERENCE BETWEEN JOINER TRANSFORMATION AND SOURCE QUALIFIER TRANSFORMATION?
You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. You need matching keys to join two relational sources in source qualifier
63. EXPLAIN USE OF UPDATE STRATEGY TRANSFORMATION
This is the important transformation,is used to maintain the history data or just most recent changes into the target table. We can set or flag the records by using these two levels. 1) Within a ses
64. WHAT ARE THE DIFFERENCE BETWEEN VIEW AND MATERIALIZED VIEW?
Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. A materialized view provides indirect access to
65. IDENTIFYING BOTTLENECKS IN VARIOUS COMPONENTS OF INFORMATICA AND RESOLVING THEM.
The best way to find out bottlenecks is writing to flat file and see where the bottle neck is .
66. WHAT ARE THE BASIC NEEDS TO JOIN TWO SOURCES IN A SOURCE QUALIFIER?
Basic need to join two sources using source qualifier: 1) Both sources should be in same database 2) The should have at least one column in common with same data types
67. THIS IS A SCENARIO IN WHICH THE SOURCE HAS 2 COLS 10 A 10 A 20 C 30 D 40 E 20 C AND THERE SHOULD BE 2 TARGETS ONE TO SHOW THE DUPLICATE VALUES AND ANOTHER TARGET FOR DISTINCT ROWS. T1 T2 10 A 10 A 20 C 20 C 30 D WHICH TRANSFORMATION CAN BE USED TO LOAD DATA INTO TARGET? 40 E
Sorter Transformation to Target 2. Source qualifier transformation to Target 1. Check the Distinct option in Sorter transformation.
68. WHAT ARE TWO MODES OF DATA MOVEMENT IN INFORMATICA SERVER?
The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and cod
69. WHAT IS PUSHDOWN OPTIMIZATIONS IN PC 8.X WITH EXAMPLE?
Use pushdown optimization to push transformation logic to the source or target database. The Integration Service analyzes the transformation logic, mapping, and session configuration to determine the
70. I HAVE WINDOWS XP. I WAS TOLD A PERSON COULD FIND OUT WHAT SITES A PERSON IS LOOKING ON YOUR COMPUTER. HOW DO YOU DO THIS? I HAVE A PERSON WHO USES MY COMPUTER, AND I THINK HE IS LOOKING AT SITES HE SHOULD NOT BE VIEWING.
Usage of stored procedure has the following advantages 1 checks the status of the target database 2 drops and recreates indexes 3 determines if enough space exists in the database 4 perfor
62. WHAT ARE THE DIFFERENCE BETWEEN JOINER TRANSFORMATION AND SOURCE QUALIFIER TRANSFORMATION?
You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. You need matching keys to join two relational sources in source qualifier
63. EXPLAIN USE OF UPDATE STRATEGY TRANSFORMATION
This is the important transformation,is used to maintain the history data or just most recent changes into the target table. We can set or flag the records by using these two levels. 1) Within a ses
64. WHAT ARE THE DIFFERENCE BETWEEN VIEW AND MATERIALIZED VIEW?
Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. A materialized view provides indirect access to
65. IDENTIFYING BOTTLENECKS IN VARIOUS COMPONENTS OF INFORMATICA AND RESOLVING THEM.
The best way to find out bottlenecks is writing to flat file and see where the bottle neck is .
66. WHAT ARE THE BASIC NEEDS TO JOIN TWO SOURCES IN A SOURCE QUALIFIER?
Basic need to join two sources using source qualifier: 1) Both sources should be in same database 2) The should have at least one column in common with same data types
67. THIS IS A SCENARIO IN WHICH THE SOURCE HAS 2 COLS 10 A 10 A 20 C 30 D 40 E 20 C AND THERE SHOULD BE 2 TARGETS ONE TO SHOW THE DUPLICATE VALUES AND ANOTHER TARGET FOR DISTINCT ROWS. T1 T2 10 A 10 A 20 C 20 C 30 D WHICH TRANSFORMATION CAN BE USED TO LOAD DATA INTO TARGET? 40 E
Sorter Transformation to Target 2. Source qualifier transformation to Target 1. Check the Distinct option in Sorter transformation.
68. WHAT ARE TWO MODES OF DATA MOVEMENT IN INFORMATICA SERVER?
The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and cod
69. WHAT IS PUSHDOWN OPTIMIZATIONS IN PC 8.X WITH EXAMPLE?
Use pushdown optimization to push transformation logic to the source or target database. The Integration Service analyzes the transformation logic, mapping, and session configuration to determine the
70. I HAVE WINDOWS XP. I WAS TOLD A PERSON COULD FIND OUT WHAT SITES A PERSON IS LOOKING ON YOUR COMPUTER. HOW DO YOU DO THIS? I HAVE A PERSON WHO USES MY COMPUTER, AND I THINK HE IS LOOKING AT SITES HE SHOULD NOT BE VIEWING.
No comments:
Post a Comment