41. TO ACHIEVE THE SESSION PARTITION WHAT ARE THE NECESSARY TASKS YOU HAVE TO DO?
Configure the session to partition source data. Install the informatica server on a machine with multiple CPU’s.
42. WHAT ARE THE TYPES OF METADATA THAT STORES IN REPOSITORY?
Following are the types of metadata that stores in the repository:- Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches
43. HOW TO RECOVER SESSIONS IN CONCURRENT BATCHES?
If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complet
44. WHAT ARE THE NEW FEATURES IN INFORMATICA 5.0?
You can Debug u r maping in maping designer You can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window You can use a dynamic l
45. WHAT ARE TWO TYPES OF PROCESSES THAT INFORMATICA RUNS THE SESSION?
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, an
46. ON A DAY, I LOAD 10 ROWS IN MY TARGET AND ON NEXT DAY IF I GET 10 MORE ROWS TO BE ADDED TO MY TARGET OUT OF WHICH 5 ARE UPDATED ROWS HOW CAN I SEND THEM TO TARGET? HOW CAN I INSERT AND UPDATE THE RECORD?
We can use do this by identifying the granularity of the target table . We can use CRC external procedure after that to compare newly generated CRC no. with the old one and if they do not match then
47. WHAT IS THE DEFAULT JOIN THAT SOURCE QUALIFIER PROVIDES?
Inner equi join.
48. WHAT ARE THE JOIN TYPES IN JOINER TRANSFORMATION?
Normal (Default) Master outer Detail outer Full outer.
49. WHAT ARE THE METHODS FOR CREATING REUSABLE TRANSFORMATIONS?
Two methods:- 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After you add a transformation to the mapping , You can promote it to the sta
50. IF YOU HAVE FOUR LOOKUP TABLES IN THE WORKFLOW. HOW DO YOU TROUBLESHOOT TO IMPROVE PERFORMANCE?
There are many ways to improve the mapping which has multiple lookups. 1) we can create an index for the lookup table if we have permissions(staging area). 2) divide the lookup mapping.
Configure the session to partition source data. Install the informatica server on a machine with multiple CPU’s.
42. WHAT ARE THE TYPES OF METADATA THAT STORES IN REPOSITORY?
Following are the types of metadata that stores in the repository:- Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches
43. HOW TO RECOVER SESSIONS IN CONCURRENT BATCHES?
If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complet
44. WHAT ARE THE NEW FEATURES IN INFORMATICA 5.0?
You can Debug u r maping in maping designer You can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window You can use a dynamic l
45. WHAT ARE TWO TYPES OF PROCESSES THAT INFORMATICA RUNS THE SESSION?
Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, an
46. ON A DAY, I LOAD 10 ROWS IN MY TARGET AND ON NEXT DAY IF I GET 10 MORE ROWS TO BE ADDED TO MY TARGET OUT OF WHICH 5 ARE UPDATED ROWS HOW CAN I SEND THEM TO TARGET? HOW CAN I INSERT AND UPDATE THE RECORD?
We can use do this by identifying the granularity of the target table . We can use CRC external procedure after that to compare newly generated CRC no. with the old one and if they do not match then
47. WHAT IS THE DEFAULT JOIN THAT SOURCE QUALIFIER PROVIDES?
Inner equi join.
48. WHAT ARE THE JOIN TYPES IN JOINER TRANSFORMATION?
Normal (Default) Master outer Detail outer Full outer.
49. WHAT ARE THE METHODS FOR CREATING REUSABLE TRANSFORMATIONS?
Two methods:- 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After you add a transformation to the mapping , You can promote it to the sta
50. IF YOU HAVE FOUR LOOKUP TABLES IN THE WORKFLOW. HOW DO YOU TROUBLESHOOT TO IMPROVE PERFORMANCE?
There are many ways to improve the mapping which has multiple lookups. 1) we can create an index for the lookup table if we have permissions(staging area). 2) divide the lookup mapping.
More Questions & Answers :-
No comments:
Post a Comment