Interview Questions.

Q1. Is It Possible To Use A Client With Different Version Than That Of Its Informatica Server?

It’s now not possible use purchaser with unique model than that of its Informatica server.

Q2. What Is A Difference Between Complete, Stop And Abort?

Complete: Allows the classes and workflows to run to completion before disabling the carrier process.

Stop: Stops all classes and workflows after which disables the service technique.

Abort: Attempts to prevent all sessions and workflows before aborting them and disabling the carrier technique

Q3. What Is A Repository And Difference Between Repository Database And Repository Service?

Repository is metadata which me it has records approximately the data(objects). It shops the facts regarding the Informatica gadgets .For eg: We have a folder say “Folder1” and three mappings has been created inside it, so all the statistics regarding all objects in mapping and the folder may be saved in repository database in kinds of tables.

Repsoitory database is a database which includes all of the metadata while the repository service is not anything but a carrier which runs on repository database and offers its offerings.

OPB_Mapping: This desk contains all the mapping names.

Q4. Pmrep And Pmcmd Command?

Pmrep and pmcmd commands are the command line interface to perform Informatica associated challenge. These command s are used maximum in shape of scripts. Pmrep is used for all repository related duties. Pmcmd is used for Informatica screen and server associated responsibilities

Eg: pmrep join –r Repository_name –d Domain_name –n Username –x password

The above command connects to repository. Once related you could create a folder in repository by means of below command

Pmrep createfolder –f Foldername –o OwnerName

Some of the pmcmd instructions:

I. Startworkflow

II. Stopworkflow

III. Waitworkflow

IV. Recoverworkflow

V. Scheduleworkflow

VI. Startask

VII. Stoptask

Q5. If Your Server Is Running On Unix And One Of The Sessions Are Keep On Running Without Loading Any Data How Would You Kill It?

Kind the below command in command spark offgrep pm

Check the identity for the walking consultation and then kill it using kill command

Kill -9 identification

Q6. How Do You Start And Stop Services In Unix Without Using Admin Console?

Infaservice.Sh startup shutdown

Q7. What Is Data Movement Mode In Informatica And Difference Between Them?

The facts motion mode depends on whether or not Informatica server will system unmarried byte or multi-byte man or woman information set.

There are  records motion modes in Informatica:

I. Unicode: It lets in two bytes for each person and makes use of the additional byte for each non ASCII individual(Such as Malaysian characters)

II. ASCII: It holds the data in a unmarried byte.

Q8. Creating A Folder Using Pmrep Command?

Pmrep create folder –f Foldername –o Owner Name

Q9. What All Are Steps In Upgradation Of Informatica Server?

To upgrade Informatica energy middle from one model to other model follow the beneath steps.

Upgrade Informatica server

Login to admin console help->About Informatica administrator and spot the upgraded version

Select on repository Action->Content->Upgrade

Select on repository motion-Content->improve customers and companies

Q10. What Is Native Users?

Native users are the users created with admin console.

Q11. What Is Meant By Ldap Users?

LDAP customers are the user which can be configured with LDAP server (additionally can be MS Active listing ) and LDAP is included with energy middle to allow customers to offer unmarried sign up.

Q12. What Could Be The Possible Reasons Of Locks By User?

Network issues occur.

A PowerCenter Client, Integration Service, Repository Service, or database gadget shuts down improperly.

Q13. Can We Create Multiple Integration Service On Single Repository?

Yes it's far possible to create multiple integration provider on single repository. This is used when you have to select one-of-a-kind code web page for special integration service in same repository

Eg: Repository : ASIA_PACIFIC_Repo is used to load the facts for nations particular to ASIA PACIFIC to target warehouse. Different Integration provider created for non English nations to aid different code page (Malaysia, China, Japan, Thailand)

Q14. I Am Not Able To Connect To The Domain With The Client Although All Services And Databases Are Up And There Is No Network Issue?

Manage person connections and locks.

Q15. What Is The Difference Between Stop And Abort Options In Workflow Monitor?

Stop waits for all going for walks gadgets to finish and then terminate the manner however abort stops the entire object strolling at once.

Eg: A workflow is in jogging country and it’s having 5 classes in it and handiest 2 classes are going for walks.

STOP: It will await the going for walks periods to finish their system and then terminate the workflow. Remaining 3 classes will not run.

ABORT: It will kill the running session immediately and hence the workflow.

Q16. What Do You Mean By Dtm And Load Manager And What Is Difference Between Load Manager And Load Balancer?

Load Balancer: The Integration Service uses the Load Balancer to dispatch responsibilities. The Load Balancer dispatches obligations to acquire foremost overall performance. It might also dispatch responsibilities to a unmarried node or across the nodes in a grid.

Data Trformation Manager (DTM) method: The Integration Service begins a DTM manner to run each Session and Command assignment inside a workflow. The DTM procedure plays consultation validations, creates threads to initialize the session, study, write, and trform data, and handles pre- and publish- session operations.

Q17. What Is Exclusive And Normal Mode For Repository Services?

Exclusive mode is a style described whilst you are making any adjustments to repository carrier. It’s like a lock while you play with repository configuration so its associated services like integration services will not be able to use its services.

Q18. What Happens When A Session Fails And You Click On Recover?

Every session has a belongings of devote c language. Commit interval is a factor and then a consultation creates a log and commits the traction at supply, goal or both degrees. For every commit c programming language it generates an identification corresponding for every row and when a session is recovered it reads the last id inserted to goal after which proceeds the loading from subsequent row.

Eg: Source is having a thousand rows and dedicate interval is about to 50 so it'll commit for each 50 rows. Now session fails at row no sixty three@Now the target rows might be devoted until 600th row as devote c program languageperiod is five@Once we get better a consultation the loading will start from 601th row.

Q19. What Is Primary And Backup Node?

Primary node is a node where a present day node or packages are jogging and backup node is described to run the domain or programs offerings while primary node is going down.

Q20. How To Go To The Older Version For A Mapping?

There is not any direct technique to revert again a mapping to previous model however it is able to be completed via the method defined below.

Right click on on the mapping->model-View records

All the versions may be listed out. Select the version you want to revert returned to and export or store its definition in nearby pressure. Rename the ultimate version with new name after which import the document

Q21. What Is Deployment Group?

A deployment institution is a global object that includes versioned objects from one or more folders. You use a deployment group to replicate the versioned items to some other folder or repository. You can use a deployment group when you need to replicate a few, however no longer all, of the gadgets in a folder. You can also use a deployment institution to duplicate items from multiple folders.

Q22. What Do Mean By Local And Global Repository?

Local repository is a repository whose items are accessible within that repository most effective.

Global repository is a repository is a repository that could percentage its objects a few of the domain in specific repository.

Eg: 

A mapping created in worldwide repository can be accessed to all repositories inside the area.

Q23. What Is An Integration Service In Informatica?

Integrations carrier is a utility carrier in Informatica which run the workflows and consultation. It tells the Informatica server how to waft the data from source to target.

Analogy: Integration provider is sort of a provider truck which carries the products (statistics) from one region to different

Q24. What Is Resilience Time?

Resilience time is the time defined in Informatica to attend before it lose the connection on a community failure.

Eg: If your resilience time is one hundred eighty sec and the community goes down so Informatica will look ahead to 180 sec and if community is set up in among, the relationship can be mounted. If the network isn't up within one hundred eighty sec so the unsaved statistics can be misplaced and the customer could be disconnected from the area or repository

Q25. What Is A Code Page?

Code web page consists of encoding to specify characters in a fixed of one or more languages.

Eg: If you have Malaysian or Chinese character for your source statistics then you have to choose the best code web page for those characters else you’ll see rectangular containers as soon as the information is loaded and processed as Informatica will no longer be capable of understand the ones characters.

Q26. While Migrating The Data From One Environment To Another Environment How Would You Manage The Connections?

While migrating the folder or workflows make certain the relationship call in each environment are identical.

In the workspace or Navigator, choose an item and click on Versioning > View History.

Select the variations you need to evaluate after which click Compare > Selected Versions.

                                                        (Or)

Select a model and click on Compare > Previous Version to evaluate a version of the item with the previous model.

Q27. What Do You Understand By Soa Of Informatica?

SOA or service oriented structure allows the Informatica to have services on dispensed machine. You can define a website on a node say node1 and repository service on node2, repository carrier on node@All nodes can be anywhere within a community. Once a request is made from purchaser it is going to the area or the gateway node after which it directs the request to the best nodes or offerings.

Q28. What Is A Node In Informatica?

A node in Informatica is logical representation of a machine.

Q29. How To Open An Older Version Of An Object In The Workspace?

To open an older version of an object within the workspace:

In the workspace or Navigator, choose the object and click on Versioning > View History.

Select the version you want to view inside the workspace and click Tools > Open in Workspace.

Note: An older version of an object is read-best, and the model number appears as a prefix before the object call. You can simultaneously view more than one variations of a non-composite object inside the workspace

Q30. Can We Create A Integration Service Without A Repository Service And Vice Versa?

It isn't possible to create an Integration service with out a repository carrier but a repository may be created without an integration carrier.

Q31. How Do You Take Back Up Of Repository?

Login to admin console. Select the repository-> Action->Backup Content

The backup content could be stored in a XML report and the vicinity of backup directory is described in area configuration.

Also you can create a script and agenda it to backup the content on positive date and time.

In script first connect with repository using pmrep command after which backup the content with the under command.

Pmrep backup

-o

[-d ]

[-f (overwrite existing output file)]

[-b (skip workflow and session logs)]

[-j (skip deploy group history)]

[-q (skip MX data)]

[-v (skip task statistics)]

Q32. Is It Possible To Create Multiple Domains On A Single Informatica Server?

Yes it's far viable to create multiple nodes on same Informatica server.

Q33. How Do You Migrate Data From One Environment To Another?

There are normally 3 varieties of methodology used for statistics migration in Informatica:

I. Copy Paste: Copy the folder or object in a single repository and click on on the destination repository and paste it(This may be achieved with pmrep command aslo)

II. Import and Export: Exporting the object definition in xml document and then uploading it to the vacation spot folder or repository

III. Deployment institution: While migrating objects in bulk the deployment institution idea comes into photo. Create a deployment organization, add then folders and object to it and then migrate the deployment organization.

Q34. Is It Possible To Define A Single Node As A Gateway Node As Well As Worker Node?

Yes it's far possible to outline a node to act as both gateway node in addition to worker node.

Eg: The domain is created on node1 and integration services and repository offerings are also going for walks at the identical machine or node. In this situation a node will behave each as a domain and a employee node.

Q35. What Is A Shortcut And Copy In Informatica And How Two Are Different With Each Other?

A shortcut is a item that's described interior a shared folder and used in different folders. Where as a replica is the replica of any item.

You can't alternate the definition of a shortcut however may be modified in case of a duplicate.

Shortcut is beneficial in cases wherein source or goal definition is equal across more than one packages.

You just need to drag the source from shared folder and alternate the connections at the same time as growing a workflow in folder.

Q36. What Are Roles And Groups And Benefits Of Using Them?

Domain is a single factor of access or the executive unit in Informatica. All the request from exceptional clients (like Designer) first reaches to area and then routed to related offerings. A gateway node is the node on which a website is defined.

Q37. Can We Create A Node As A Gateway Node And The Same Node Can Be Assigned To A Grid?

Yes it's miles viable assign a gateway node to a grid.

Q38. Can We Create Two Repositories On Same Database Instance In Oracle?

It isn't always feasible to create  repositories on identical instance of database in oracle because it may be developing the metadata tables for repository. However it is possible to create two repositories in oracle on same server if the database instance is different.

Q39. How Would You Copy The Content Of One Repository To Another Repository(the New Repository Is Not Having Anything In It)?

Backup the repository using pmrep and the repair the content on new repository.

Q40. How Would You Join A Node To The Already Existing Domain?

Becoming a member of a node to an existing area can be archived at the same time as installing Informatica.

Eg: Server is on machine1 and the new node is on machine@Then go to machine2-Open Installer->be a part of node to domain even as configuring area and offer the existing domain details.

Q41. What Is Dr Strategy For Informatica Project?

A backup node can be defined for all nodes and services, so incase if the primary node goes down the backup node can take over the control.

Note: You must have the license to create a backup node.

Q42. What All Challenges You Faced In Informatica In Your Last Project As An Admin And How Did You Resolve Them?

The oracle customer was not set up properly on Informatica server and also the tns entry in oracle consumer become not well. During Informatica server set up the area became no longer able to ping to the database because of the consumer trouble.

The Informatica admin console turned into not beginning due to open files in OS

Used ulimit –n command to check open files after which increased-nowait]

[ runInsName] workflow

Q44. What Is A Grid In Informatica?

Grid in Informatica is used for load balancing. A grid is not anything however a mixture of nodes which distributes the request amongst them.

Eg: node1, node2, node3, node4 are assigned in a grid. 10 workflows started out concurrently. Now in place of giving burden to a unmarried node to run the 10 workflows the request for jogging workflows could be distributed to all nodes.

Q45. What Is Difference Between A Gateway Node And Worker Node?

A gateway node is a node on which domain is described and it act as a router or administrator to all services. All other nodes in a domain are employee nodes in which utility services like Informatica services, repository offerings might be jogging.

Q46. What Do You Mean By Parameter File? Why Do We Use It And What All Things We Can Define In A Parameter File?

Parameter document is a report assigned to a session which has configuration details in it. The parameter file is used for reusability. Below matters are described in it.

Connections, mapping parameter, mapping variable.