81. HOW TO MOVE THE MAPPING FROM ONE DATABASE TO ANOTHER?
1. Open the mapping you want to migrate. Go to File Menu - Select 'Export Objects' and give a name - an XML file will be generated. Connect to the repository where you want to migrate and then select
82. HOW DO U CHECK THE SOURCE FOR THE LATEST RECORDS THAT ARE TO BE LOADED INTO THE TARGET. I.E. I HAVE LOADED SOME RECORDS YESTERDAY, TODAY AGAIN THE FILE HAS BEEN POPULATED WITH SOME MORE RECORDS TODAY, SO HOW DO I FIND THE RECORDS POPULATED TODAY.
a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port f
83. WHAT ARE VARIABLE PORTS AND LIST TWO SITUATIONS WHEN THEY CAN BE USED?
We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when
84. CAN YOU USE THE MAPING PARAMETERS OR VARIABLES CREATED IN ONE MAPING INTO ANY OTHER REUSABLE TRANSFORMATION?
Yes.Because reusable tranformation is not contained with any maplet or maping.
85. PARTITIONING, BITMAP INDEXING (WHEN TO USE), HOW WILL THE BITMAP INDEXING WILL EFFECT THE PERFORMANCE
Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm
86. HOW A TWO DIMENSION ARRAY IS INITIALIZE WITH POINTER?
#include void main() { int size; cout<<"Size "; cin>>size; int **p=new int *[size.; for(int i=0;i
87. WHAT R THE TYPES OF GROUPS IN ROUTER TRANSFORMATION?
A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output
88. THERE ARE 1000 SOURCE TABLES CONTAINING THE SAME DATA WITH DIFFERENT FILE FORMATS, NOW I WANT TO LOAD INTO A SINGLE TARGET TABLE. HOW TO ACHIEVE ?
first u should convert diff. file format to one format then create 1 to 1 mapping,run it and see the o/p in unix whether file is posted or not.
89. HOW CAN U COMPLETE UNRECOVERABLE SESSIONS?
Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica S
90. HOW U WILL CREATE HEADER AND FOOTER IN TARGET USING INFORMATICA?
If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties
1. Open the mapping you want to migrate. Go to File Menu - Select 'Export Objects' and give a name - an XML file will be generated. Connect to the repository where you want to migrate and then select
82. HOW DO U CHECK THE SOURCE FOR THE LATEST RECORDS THAT ARE TO BE LOADED INTO THE TARGET. I.E. I HAVE LOADED SOME RECORDS YESTERDAY, TODAY AGAIN THE FILE HAS BEEN POPULATED WITH SOME MORE RECORDS TODAY, SO HOW DO I FIND THE RECORDS POPULATED TODAY.
a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port f
83. WHAT ARE VARIABLE PORTS AND LIST TWO SITUATIONS WHEN THEY CAN BE USED?
We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when
84. CAN YOU USE THE MAPING PARAMETERS OR VARIABLES CREATED IN ONE MAPING INTO ANY OTHER REUSABLE TRANSFORMATION?
Yes.Because reusable tranformation is not contained with any maplet or maping.
85. PARTITIONING, BITMAP INDEXING (WHEN TO USE), HOW WILL THE BITMAP INDEXING WILL EFFECT THE PERFORMANCE
Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm
86. HOW A TWO DIMENSION ARRAY IS INITIALIZE WITH POINTER?
#include void main() { int size; cout<<"Size "; cin>>size; int **p=new int *[size.; for(int i=0;i
87. WHAT R THE TYPES OF GROUPS IN ROUTER TRANSFORMATION?
A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output
88. THERE ARE 1000 SOURCE TABLES CONTAINING THE SAME DATA WITH DIFFERENT FILE FORMATS, NOW I WANT TO LOAD INTO A SINGLE TARGET TABLE. HOW TO ACHIEVE ?
first u should convert diff. file format to one format then create 1 to 1 mapping,run it and see the o/p in unix whether file is posted or not.
89. HOW CAN U COMPLETE UNRECOVERABLE SESSIONS?
Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica S
90. HOW U WILL CREATE HEADER AND FOOTER IN TARGET USING INFORMATICA?
If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties
No comments:
Post a Comment