//8) Which statement is true of Worklets but NOT of mapplets? a) They are reusable by nature b) They encapsulate part of the functionality of a workflow/Mapping c) They have their own Designer tool d) They can be nested -- d) //7) Which is not a valid option of UPDATE STRATEGY transformation a) DD_DELETE b) DD_INSERT c) DD_UPDATE d) DD_TRUNCATE --d) //6) A Pipeline consists of a a) source qualifier, all the transformations and targets that receive data from the source qualifier b) source qualifier and all the transformations from the source qualifer but not target c) source qualifier , all the transformations and all the targets in the mapping from other sources as well d) none of the above --a) //4) Which SCD type stored partial history? a) SCD type1 b) SCD type2 c) SCD type3 d) none of the above --c) //3) Which is not a valid options in target load type property? a) BULK b) NORMAL c) FULL d) A&B --c) //10) Difference between stop and abort a) Stop-Stops the session Abort - Kills the session b) Stop - Kills the session Abort - stops the session c) Both stops the session d) None of the above --a) //13) Which of the following changes to mappings can cause partitioned session failure? a) Delete a transformation that was a partition point b) Add a transformation that is a default partition point c) Move a transformation that is a partition point to a different pipeline d) All the above --d) //12) Which reference is used to call an unconnected lookup transformation? a) :LKP b) :LPK c) LKP d) no reference is required --a) //11) How to determine whether the incoming record already exists in the target table? a) Using Router Transformation b) Using Lookup Transformation c) Using Aggregator Trasnformation d) Writing a select query on toad --b) //9) A Scheduling tool from BMC software a) ans) CONTROL M b) Autosys c) workflow scheduler d) Maestro --a) //16) Which options is false for built - in variables a) Built-in variables return either run-time or system information b) Values can be defined for built-in variables in a workflow or session parameter file c) The integrtion service sets the values for built in variables d) Built in variable can be used in expression in Designer --b) //20) which of the following objects can be scheduled? a) Workflows b) Session c) Worklets d) Command Tasks --a) //19) Which components are required to run a debug session? a) The Designer b) The Designer and the Workflow Manager c) The Designer and a running Informatica server d) The Designer, the Workflow Manager and a running informatica server --c) //18) Which is not a valid SCD type 2? a) Flag b) Date Range c) Version d) Type --d) //17) If we enter a space between the parameter name and the equal sign, the Integration Service interprets the space as a) part of the parameter name b) part of the parameter value c) Ignores it d) Throws an error --a) //14) Which one of the following statements is NOT correct? a) Workflows must be within Tasks to be executed b) Tasks must be within Workflows to be executed c) Workflow links may contain conditions d) Workflows may contain worklets --a) //15) The Integration Service looks for the start value of a variable in the folloing order a) 1. Value in the parameter file 2. Value saved in the respository (if the variable is persistent) 3. User-Specified default value 4. Datatype default value b) 1. Value saved in the respository (if the variable is persistent) 2. Value in the parameter file 3. User-Specified default value 4. Datatype default value c) 1. Datatype default value 2. Value saved in the respository (if the variable is persistent) 3. Value in the parameter file 4. User-Specified default value d) 1. User-Specified default value 2. Datatype default value 3. Value saved in the respository (if the variable is persistent) 4. Value in the parameter file --a) 1) In a sequential batch, can we run the session if previous session fails? a) Yes. The second session will run even if the first session fails b) the second session has no dependency of the first session c) We cannot run sessions sequentially in workflow manager d) the second session will by default fails if the first session fails --a) //5) Which of the following statements is not true about mapplet a) Mapplets and mapplet ports display differently in the Mapplet Designer and the Mapping Designer b) If you use a sequence generator tranformation, you must use a reusable sequence generator transformation. c) A Mapplet can be active or passive depending on the tranformations in the mapplet d) COBOL Sources and XML sources can be used in mapplet --d) 2) Which types of objects can be visible in the Repository Manager Navigator workflow? a) Mappings, repository users, and source and target definition b) Repository users, folders and sub folders and source and target definitions c) Business components, Mappings, reusable transformations d) Mappings and mapplets, Integration services and folders and subfolders ? 1) Mapplet should contain atleast one ____________ with one connected port. a) Input Transformation b) Output Transformation c) Sequence generator d) None of the above --b) 2) What should be used To assign null values to $PMBadFileDir? a) $PMBadFileDir=NULL b) $PMBadFileDir='/0' Answer/*-- To assign a null value, set the parameter or variable value to or simply leave the value blank. $PMBadFileDir= $PMCacheDir= */ 3) Which of them is not a partition . Key hash partition, Hash auto keys, database, Key Range partion? Answer: Key Hash /* Type of partitions: --Round robin: Distributes data evenly and does not need to group data --Hash partition: uses hash function to group data among partitions based on the partition key. Types: 1) Hash auto key( compound partition key, and can be used after rank/ sorter/ aggr transformation) 2) Hash user key:( user defined partion key) --Key range: User can specify 1 or more ports and specify range to form the compound partion key --Pass through: Passes rows from 1 partition to another without redistributing the data --Database: Queries DB for the partition 4) Which partition to be used if the target table is partitioned on Key range a) round robin b) Hash auto keys c) Key range d) None of the above -- c 5) If the mapping is deisgned to be "Source based commit", which partion needs to be used? a) round robin b) Data Driven c) 6) What is not true about $$$SESSIONSTARTTIME and SESSIONSTARTTIME a) $$$SESSIONSTARTTIME used in sql overide b) SESSIONSTARTTIME used in expression c) $$$SESSIONSTARTTIME can not be used in mapping and mapplets as filter condition -- a) 7) Session has failed after loading 10000 records into the table. Then if you want to trigger from 10001th record? a) Restart recovery b) Cant be resumed c) Session restart -- a) Restart recovery. 8) If the LKP table has more data than LKP Cache. Then a) Session will exec with error. b) Session will fail. c) No impact d) System will hang -- a/d) Doubt 9) Which of them is not a property in the workflow task a) EndTime b) ErrName c) Status -- b) ErrName 9) Which of them is not a property in the Session task a) EndTime b) Status c) Condition -- c) Condition 10) Workflow Tasks: Command Control Decision Email Event-Wait Session Assignment Timer 11) get_date_part(date_shipped,'HH') a)0 b) Null c)12 d)None --a) 0 12)which ic default recovery stragegy for session a) restart 13)Different ports in various transformation 14) -------------------------------------------------------------------------------------- -- Dependency window -- Wch partition to be used for Source based partition to load to Relational DB or flat file -- If u delete a port in the mapplet a) mapping will get invalidate b) mapplet will get invalidate c) mapping will continue to be valid d) none -- SessionStartime will give "date/time" o/p and $$$SessionStartime will give "string" o/p. --Which SCD type stored full history? a) SCD type1 b) SCD type2 c) SCD type3 d) none of the above -- In wch transformation will the flag to set the row for insert/update/delete/error be made? a) LKP b) Filter c) Router d) sorter --Where will the param be declared? a) designer b) wf c) -------------------------------------------------------------------------------------- https://informaticareference.wordpress.com/2011/12/06/date-functions/ /* Session pre defined expressions: 1. Starttime 2. Endtime 3. Status 4. ErrorCode 5. Error Msg 6. FirstErrorCode 7. FirstErrorMsg 8. SrcFailedRows 9. SrcSuccRows 10. TgtFailedRows 11. TgtSuccRows 12. PrevTaskStaus 13. TotalTrasEror Workflow : 1. Starttime 2. Endtime 3. Status 4. PrevTaskStatus 5. ErroCode 6. ErrorMsg SUPPOSE SESSION IS CONFIGURED WITH COMMIT INTERVAL OF 10,000 ROWS AND SOURCE HAS 50,000 ROWS. EXPLAIN THE COMMIT POINTS FOR SOURCE BASED COMMIT AND TARGET BASED COMMIT. /*Source based commit will commit the data into target based on commit interval.so,for every 10,000 rows it will commit into target. Target based commit will commit the data into target based on buffer size of the target.i.e., it commits the data into target when ever the buffer fills.Let us assume that the buffer size is 6,000.So,for every 6,000 rows it commits the data. ? Target-based commit. The Informatica Server commits data based on the number of target rows and the key constraints on the target table. The commit point also depends on the buffer block size and the commit interval. ? Source-based commit. The Informatica Server commits data based on the number of source rows. The commit point is the commit interval you configure in the session properties. */ WHAT R THE TYPES OF METADATA THAT STORES IN REPOSITORY? Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches Short cuts Source definitions Target defintions Transformations CAN U START A BATCHES WITH IN A BATCH? /*U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch. */ WHAT R THE DIFFERENT THREADS IN DTM PROCESS? Master thread: Creates and manages all other threads Maping thread: One maping thread will be creates for each session.Fectchs session and maping information. Pre and post session threads: This will be created to perform pre and post session operations. Reader thread: One thread will be created for each partition of a source.It reads data from source. Writer thread: It will be created to load data to the target. Transformation thread: It will be created to tranform data. WHAT R THE OPTIONS IN THE TARGET SESSION OF UPDATE STRATEGY TRANSFORMATION? Insert Delete Update Update as update Update as insert Update else insert truncate table WHAT IS THE DEFAULT SOURCE OPTION FOR UPDATE STRATEGY TRANSFORMATION? Data driven. WHAT IS TRACING LEVEL? Tracing level determines the amount of information that informatcia server writes in a session log. WHILE RUNNING A SESSION, WHAT ARE THE TWO FILES IT WILL CREATE? Session Log file and Session Detail file. Besides it also creates the following files if applicable - reject files, target output file, incremental aggregation file, cache file. WHAT IS THE DIFF B/W STOP & ABORT IN INFORMATICA SESSION LEVEL ? Stop:We can Restart the session Abort:WE cant restart the session.We should truncate all the pipeline after that start the session. IF THE WORKFLOW HAS 5 SESSION AND RUNNING SEQUENTIALLY AND 3RD SESSION HASBEEN FAILED HOW CAN WE RUN AGAIN FROM ONLY 3RD TO 5TH SESSION? 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 complete successfully, you can recover the session as a standalone session.To recover a session in a concurrent batch:1.Copy the failed session using Operations-Copy Session.2.Drag the copied session outside the batch to be a standalone session.3.Follow the steps to recover a standalone session.4.Delete the standalone copy. What happens if Informatica server doesn't find the session parameter in the parameter file? Workflow will fail. If index cache file capacity is 2MB and datacache is 1 MB. If you enter the data of capacity for index is 3 MB and data is 2 MB. What will happen? Nothing will happen based the buffer size exists in the server we can change the cache sizes. Max size of cache is 2 GB. Using unconnected lookup how we you remove nulls n duplicates? We can't handle nulls and duplicates in the unconnected lookup. We can handle in dynamic connected lookup. I have the Administer Repository Privilege, but I cannot access a repository using the Repository Manager. To perform administration tasks in the Repository Manager with the Administer Repository privilege, you must also have the default privilege Browse Repository. You can assign Browse Repository directly to a user login, or you can inherit Browse Repository from a group. How does read permission affect the use of the command line program, pmcmd? To use pmcmd, you do not need to view a folder before starting a session or batch within the folder. Therefore, you do not need read permission to start sessions or batches with pmcmd. You must, however, know the exact name of the session or batch and the folder in which it exists. With pmcmd, you can start any session or batch in the repository if you have the Session Operator privilege or execute permission on the folder. I do not want a user group to create or edit sessions and batches, but I need them to access the Server Manager to stop the Informatica Server. To permit a user to access the Server Manager to stop the Informatica Server, you must grant them both the Create Sessions and Batches, and Administer Server privileges. To restrict the user from creating or editing sessions and batches, you must restrict the user's write permissions on a folder level. Alternatively, the user can use pmcmd to stop the Informatica Server with the Administer Server privilege alone. I created a new group and removed the Browse Repository privilege from the group. Why does every user in the group still have that privilege? Privileges granted to individual users take precedence over any group restrictions. Browse Repository is a default privilege granted to all new users and groups. Therefore, to remove the privilege from users in a group, you must remove the privilege from the group, and every user in the group. What are the different types of locks? ? Read lock. Created when you open a repository object in a folder for which you do not have write permission. Also created when you open an object with an existing write lock. ? Write lock. Created when you create or edit a repository object in a folder for which you have write permission. ? Execute lock. Created when you start a session or batch, or when the Informatica Server starts a scheduled session or batch. ? Fetch lock. Created when the repository reads information about repository objects from the database. ? Save lock. Created when you save information to the repository. What is the use of auxiliary mapping? Auxiliary mapping reflects change in one table whenever there is a change in the other table.