Informatica Interview Questions ALL-Interview.com
Click on the Question to read answer and report incorrect category/incorrect Questions or answers How to list Top 10 salary, without using Rank Transmission? what is the economic comparison of all the Informatica versions? what is Data Ware Housing? How to create slowly changing dimension in informatica? How do you handle two sessions in Informatica How to implement de-normalization concept in Informatica Mappings? Do v use any tool for Handling Performance tuning in real time? What's the difference between source and target object definitions in Informatica? What is the advantages of converting stored procedures into Informatica mappings? What is the purpose of using UNIX commands in informatica. Which UNIX commands are generally used with informatica? Explain about scheduling real time in informatica What is the difference between SQL Overriding in Source qualifier and Lookup transformation? How do you define fact less Fact Table in Informatica? Does Informatica provide a SAS exit in any of its products? What is the role/use of unix in informatica What is informatica What is informatica power how much hike in the 6th pay commission for my basic pay of rs.5500? Difference between data mining and data warehousing What is MODEL is Data mining world? How can we load the normalized data ( Vertical data) to (Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. how to do estimation before staring development in project. Here estimation in the sense sense how many associates are required, etc to complete the project. What are the ETL tools available in DWH? Diff b/w Shortcut and reusable Object ? how we do performance tuning in informatics What is 'Power Center Push down Optimization Option' in INFORMATICA? How to deal with it without changing mapping? What is "Change cache" in Informatics? can we create index and drop index in existing table while using informatica If we are using an aggregate but forget to mention the group by port .what will be the output?? Informatics software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6) How/where can i install Informatics software with oracle or teradata as database How to transform normalized data to denormalized denormalized form in informatics? Is there any logic or any transformations to achieve this? why do we go for update strategy tr in SCD rather using the session properties? How many mapplets u have created? and what is the logic used LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default?Using the Look UP Condition How many types of relational conditions we can make Dependency Errors in Informatica?Do u got any dependency problems while running session? What is Throughput in Informatics,How it works, Where I can find this option to check? Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions How can i catch the Duplicate Rows From Sorter Trans in a Separate Target Table ? how can we perform incremental aggregation?explain with example? difference between shortcut and reusable transformation
transformation and the aggregator transformation. how to do estimation before staring development in project. Here estimation in the sense sense how many associates are required, etc to complete the project. What are the ETL tools available in DWH? Diff b/w Shortcut and reusable Object ? how we do performance tuning in informatics What is 'Power Center Push down Optimization Option' in INFORMATICA? How to deal with it without changing mapping? What is "Change cache" in Informatics? can we create index and drop index in existing table while using informatica If we are using an aggregate but forget to mention the group by port .what will be the output?? Informatics software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6) How/where can i install Informatics software with oracle or teradata as database How to transform normalized data to denormalized denormalized form in informatics? Is there any logic or any transformations to achieve this? why do we go for update strategy tr in SCD rather using the session properties? How many mapplets u have created? and what is the logic used LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default?Using the Look UP Condition How many types of relational conditions we can make Dependency Errors in Informatica?Do u got any dependency problems while running session? What is Throughput in Informatics,How it works, Where I can find this option to check? Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions How can i catch the Duplicate Rows From Sorter Trans in a Separate Target Table ? how can we perform incremental aggregation?explain with example? difference between shortcut and reusable transformation
difference between source based commit? and target based commit? which is better with respect to performance? What is Target Update Override? What is the Use ? What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation? why sequence generator should not directly di rectly connected to joiner transformation ? How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 8/4/2008 O/P - shuould have only one id with the min(date) How to create a mapping for this How Schedule the Informatica job in "Unix Corn Scheduling tool" ? How upload the Mainframe source For Informatics ? what is the difference between persistence persistence and dynamic caches? On which conditions we are using these caches? Change Data Capture in Informatics,using Incremental A ggregation.How we identify the these data in i n Target table. What are set operators in Oracle what is the Source File limitation in Informatica?how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files fil es are different How generate Sequence Numbers to Target Table (with out using Sequence Gen Trans,Rank Trans). How scd will work ? When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? How do we do change data capture? Is this Slowly changing Dimension technique? What is the difference between Connected and Unconnected Look up Transformation.Give one or two examples what are the difference between active and passive transformation with some examples. What is a flat file and how to use flat file in informatica What is a surrogate key?Why we use it in a mapping? How Union Transformation is an Active Trans What are partitions in informatics and which one is used for better performance? when we develop a project what are the performance issue will raise?? if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the
constraint it performed better? what are UNIX commands frequently used in informatics? what is diff between grep and find Can we use different look up transformations for a same look up table (look up condition may or may not be same)with different output ports?How the cache files will be affected? Diff B/W MAP Parameter,SESSION Parameter, Database connection session parameters.?Its possible to Create 3parameters at a time?If Possible which one will fire FIRST? Which is costliest transformation? costly means occupying more memory? how to run two work flow(not a sessions) sequentially, what is the process. explain detailed information. how to run 2 work flows sequentially. respond what is the process? what is the monster dimension give me one example Which gives the more performance when compare to fixed width and delimited file ?and why? What are the challenges of Data Warehousing in the future? why we use source qualifier transformation? when we go for unconnected look up transformation? and why? installation procedure for power center 8.1.1 especially domain_con fig how to use parameter files Is it passive or active when check and unchecked the box of DISTINCT in Sorter transformation? why? explain about sales project in informatica After we make a folder shared can it be reversed?Why? Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static need for registering a repository server How to display First letter of Names in Caps? How to merge First Name & Last Name How to retrieve last two days updated records? How to get EVEN & ODD numbers separately?
How to extract original records at one target & Duplicate records at one target? How to display null values on a target & non-null values on a target? How to update records in Target, without using Update Strategy? Is it possible to have "5 source & 5 Target" in single mapping? Without using Look up & Sequence Generator, How to generate Sequence? In joiner, how to load Master table in Target? How to compare Source and Target table, without using dynamic look up? How to join 2 tables, without using any condition? Without source how to insert record to target? How to find from a source which has 10,000 records, find the average between 500th to 600th record? how will you remove the duplicate records from flat file without using sorter? how will you get 21 to 30 record from 50 records? How will you combine 3 different sources with a single source? How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam") How will you display "Mr" for male & "Mrs" for female in target table? how to join the two flat files using the joiner t/r if there is no matching port? How many cubes create from a single model? What is the difference between Oracle performance and Informatics Performance? Which performance is better? how to declare array in plsql? what is plsql table? what is the difference between lookup override and joiner? How to send duplicates to one target and unique rows to one target?target is empty How to delete duplicate records in a flat file source? What is a poling?
How to load a relational source into file target? What are the phases in SDLC? How the Informatica Server reads parameter file? How to load relational source into file target? What is A complex mapping? What is a data modeling? how to move the mappings from your local machine to Clint place? Difference between filter and router? what are the parameter and variable What is the difference between procedure and stored procedure? what is the diff b/w target load plan and cbl? how can u load the data in time dimension? what is the diff b/w union and joiner and look up? what is the process we used in joiner transformation,there is no matching column in sources? what is the process of target load planing? what is lookup override? how many types transformations supported by sorted i nput? How to delete duplicate record in Informatics? What is the difference between Junk and Confirmed Dimension? where can be used that one in Informatica? What is the difference between Bitmap and Btree index? how to calculate the optimum cache size in aggregate transformation? what target override?what advantages it has compare to target update what is cdc? how to use it in creation of mappings? how do we create datamart?
we r using aggregator with out using group by? daily how much amount of data send to production? How to write a procedure for a date which is in three different formats,and you want to load into data warehouse in any single date format Ho to handle changing source file counts in a mapping? what is mapping optimization? what are the techniques for that how to obtain performance data for individual transformations. can a port in expression transfer be given the name DISTINCT task is running successfully but data is not loaded why? what is galaxy repository? what is mean by grouping of condition column in look up transformation? in reporting we add some new objects,how we get the count of the newly added objects to the report how can u generate sequence of values in which target has more than 2billion of records. how can u connect client to Ur informatica sever if server is located at different place( not local to the client) what is upstream and downstream transformation? what are testing in a mapping level please give brief explanation how to load duplicate row in a target how can u tune u r informatica mappings how can u approach u r client which quality process u can approach in ur project what is difference b/w joiner and union transformation What is the "File Repository" and how can we use that in the Informatica ? give one example of the Process ? how to run the batch using pmcmd command What is the main data object present in between source and target
What is the term PIPELINE in informatica ? What is checksum terminology in informatica? Where do you use it ? how to load only the first and last record of a flat file into the target? All active transformations r passive or not? which T/r we can use it mapping parameter and mapping variable? and which one is reusable for any mapping mapping parameter or mapping variable? what r the properties of work flow? and write query to select dept more ten employees in dept.? what is file list concept in informatica how can we update without using update transformation.wt is push down operation in informatica.which look up gives more tuning performance. if so why what we require for D.modeling? what transformations are used for Variable port? how tokens will generate? .prm with replace .txt is possible? what is Dynamic look up Transformation? when we use?how we use? what is inline view? when and why we Use How to generate the HTML output using Informatica. how to work with mapplet designer in informatica? what is full process of Information source to target just like stg to production and development what are the differences between power center 8.1 and power center 8.5? What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter? how can we load 365 flat file to a single fact table (target) as a history load in single mapping? differences between Informatica 7.1 and 8.1? why u go for dimensions ? how many tasks are there in informatica ?
what is incremental loading ? how do u get the first record from 50,000 records ? in which situations do u go for sequence generator ? in which situations do u go for scds ? in which situations do u go for starflake schema ? in which situations do u go for snowflake schema ? What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects? WHAT IS TEXT LOAD? HOW DO U IMPLEMENT SCHEDULING IN INFORMATICA? WHAT IS THE MEANING OF UPGRADATION OF REPOSITORY? What is the actual work done in Development and in the production depts in building a data warehouse. Which dept is more interesting and career oriented how to duplicates from expression transformation without using sorter before that difference between stop and abort how can v eliminate duplicate values from look up without overriding sql? can we update records in target using update strategy without generating primary key ? explain if we have duplicate records in a table temp n now i want to pass unique values to t1 n duplicate values to t2 in single mapping?how how do u use sequence created in oracle in informatics? Explain with an simple example what is dimension table? what is fact table? whether Sequence generator T/r uses Caches? then what type of Cache it is what is shared Cache. when we will use shared Cache? explain different types of modeling. how u know when to use a static cache and dynamic cache in look up transformation.
what is the tracing level? and difference between trace in normal and verbose and non verbose? how much memory (size) occupied by a session at run time how DTM buffer size and buffer block size are related why cant we put a sequence generator or up strategy transformation before joiner transformation? In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions. What is difference between Informatica 6.2 Work flow and Informatica Work flow 7.1 What is a diff between joiner and look up transformation Without using any transformations how u can load the data into target? why we need to use unconnected transformation? where we can static cache,dynamic cache What is incremental aggregation and how it is done? How could we generate the sequence of key values without using sequence generator transformation in the target ?? In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use? Why is meant by direct and indirect loading options in sessions? what is the logic will you implement to load data into a fact table from n dimension tables? How will u pass the data with out debugger? How will u find weather dimension table is big in size of a fact table? explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ??? What is Fact less fact table ? what is the (UTC) unit test cases with the examples in informatica Whats the difference between $,$$,$$$ From where we can start or use pmcmd?
In real time scenario where can we use mapping parameters and variables? By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target? THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO ONE FORMAT WITHOUT USING EXPRESSION TRANSFORMATION ? A TABLE CONTAINS SOME NULL VALUES.HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET? ONE FLAT FILE IS THERE WHICH IS COMMA DELIMETED,HOW TO CHANGE THAT COMMA DELIMITER TO ANY OTHER AT THE TIME OF RUNNING? two tables from two different databases r there,both having same structure but different data,how to compare these two tables ? TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ? IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ? explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | explain what should be the normalizer column(s) The GCID column 2)Also explain the Ni-or-1 rule. what is Fact table Partitioning? How to use the Oracle Analytic functions in Informatica WHAT IS FACT TABLES? WHAT IS UPDATE OVERRIDE,DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ? HOW DO YOU CONNECT TO REMOTE SERVER? WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT,UPDATE OPERATION ? HOW DO YOU PERFORM INCREMENTAL LOAD? what are the reusable tasks in informatica ? if a session is failed after a transformation,from where that session will run again , i.e . from beginning or from that transformation what is the function of 'F10' informatica? HOW TO GET THE LATEST DATA IN SCD ? two types of data are there ,one is mainframe and the other is ASCII format . in informatica how can you get both the data in a single format in ASCII .
in unconnected look up , what are the other transformations , that can be used in place of that expression transformation ? what are the transformations that are used in data cleansing ? and how data cleansing takes place ? how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse Is Flat File Contains the Dynamic Cache what r the transformations that r not involved in mapplet? What are differences between Informatica 7.1 and 6.1 Can you use one mapping to populate two tables in different schemas How do you take care of security using a repository manager if the session fails after 100 records again we have to starts the session or we go for recovery session how the server recognizes , if the session fails after loading the 100 records in to the target what is the difference between onsite & client site? what is unit testing & how it is done? what is metadata? how do u tune queries? what is scd? difference between connected and unconnected lookups? what happens when a batch fails? what is parallel querying and what r hints what r the values that r passed between informatics server and stored procedure? What is version controlling in informatica? What is scd methodology? surrogate keys usage in Oracle and Informatica? What is star and snowflake schema?
what is Kimball and Inmon methodologies? how do u move the code from development to production? why do u use shortcuts in informatica? What is the file name which you need to configure in UNIX while installing infromatica? What happens if you increase commit intervals and also decrease commit Explain grouped cross tab? What is hash partition? What is the approximate size of data warehouse What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally? What is the difference between view and materialised view? How is Data Models Used in Practice? What is an MDDB? What is the difference between MDDBs and RDBMSs? What is active and passive transformation? Why do we use DSS database for OLAP tools? What is up date strategy and what are the options for update strategy? What is staging area? What is a look up function? What is default transformation for the l ook up function? What is query panel? How can you define a transformation? What are different types of transformations in Informatica? Which kind of index is preferred in DWH? What is power play plug in? What is difference macros and prompts? What is Cognos script editor? What is IQD file?
What is the Difference between Power Play transformer and power play reports? What is the capacity of power cube? What is fact less fact schema? What is meta data and system catalog? What is operational data source (ODS)? What are the Advantages of denormalized data? After dragging the ports of three sources(sql server,oracle,informix) to a singl e source qualifier, can you map these three ports directly to target? What are the circumstances that informatica server results an unrecoverable session? How can you recover the session in sequential batches? How to recover the standalone session? What is difference between stored procedure transformation and external procedure transformation? What are the scheduling options to run a session? what is incremental aggregation? What are the new features in Informatica 5.0? How can u work with remote database in informatica?did you work directly by using remote connections? What is power center repository? What is Performance tuning in Informatica? what are the transformations that restricts the partitioning of sessions? What is difference between partitioning of relational target and partitioning of file targets? How can you access the remote source into your session? What is parameter file? What are the session parameters? How can u stop a batch?
Can you start a session inside a batch individually? Can you start a batches with in a batch? In a sequential batch can u run the session if previous session fails? What are the different options used to configure the sequential batches? What is a command that used to run a batch? When the informatica server marks that a batch is failed? How many number of sessions that u can create in a batch? Can you copy the batches? What is batch and describe about types of batches? What is polling? In which circumstances that informatica server creates Rej ect files? What are the out put files that the informatica server creates during the session running? What are the data movement modes in informatca? What are the different threads in DTM process? What is DTM process? What are the tasks that Loadmanger process will do? Why you use repository connectivity? How the informatica server increases the session performance through partitioning the source? To achieve the session partition what r the necessary tasks u have to do? Why we use partitioning the session in informatica? Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server? Define mapping and sessions? What is meta data reporter? What are the new features of the server manager in the informatica 5.0?
What are two types of processes that informatica runs the session? How can you recognize whether or not the newly added rows in the source r gets insert in the target? What are the different types of Type2 dimension mapping? What are the mappings that we use for slowly changing dimension table? What are the types of mapping in Getting Started Wizard? What are the types of mapping wizards that r to be provided in Informatica? What are the options in the target session of update strategy transformation? What is Datadriven? What is the default source option for update strategy transformation? Describe two levels in which update strategy transformation sets? what is update strategy transformation ? What are the basic needs to join two sources in a source qualifier? What is the default join that source qualifier provides? What is the target load order? What are the tasks that source qualifier performs? What is source qualifier transformation? Why we use stored procedure transformation? What are the types of groups in Router transformation? What is the Router transformation? What is the Rank index in Rank transformation? What are the rank caches? How the informatica server sorts the string values in Rank transformation? Which transformation should we use to normalize the COBOL and relational sources? What are the Differences between static cache and dynamic cache?
What are the types of look up caches? what is meant by lookup caches? Why use the lookup transformation ? what is the look up transformation? What are the joiner caches? What are the join types in joiner transformation? what are the settings that u use to configure the joiner transformation? In which conditions we can not use joiner transformation (Limitations of joiner transformation) ? What are the differences between joiner transformation and source qualifier transformation? How can you improve session performance in aggregator transformation? Can you use the mapping parameters or variables created in one mapping into another mapping? What are the mapping parameters and mapping variables? What are the unsupported repository objects for a mapplet? What are the methods for creating reusable transformations? What are the reusable transformations? How many ways you create ports? What are the connected or unconnected transformations? What are the designer tools for creating transformations? what is a transformation? How can you create or import flat file definition in to the warehouse designer? Which transformation should u need while using the cobol sources as source definitions? To provide support for Mainframes source data,which files r used as a COBOL files Where should you place the flat file to import the flat file definition to the designer How Many ways you can update a relational source definition and what are they?
While importing the relational source definition from database,what are the meta data of source U import? What are parallel queries and query hints? Explain reference cursor? What is difference between Mapplet and reusable transformation? How many repositories can we create in Informatica? What is the Hierarchy of DWH? Explain grouped cross tab? What is the Difference between DSS & OLTP? What is source qualifier? What are mapping parameters and variables in informatica? what are precession,post session success and post session failure commands ? How to identify bottlenecks in sources,targets,mappings,work flow,system and how to increase the performance? When do we use dynamic cache and static cache in connected and unconnected look up transformations? What are the different threads in DTM process? How to enter same record twice in the target table,explain? What is fact table granularity? What are reusable transformations in how many ways we can create them? What is confirmed dimension and fact? What are the two modes of data movement in informatica sever? What is the difference between OLTP and ODS? AT the max how many transformations and mapplets can we use in a mapping ? How can we eliminate duplicate rows from flatfile,explain? If we have look up table in work flow how do you troubleshoot to increase performance? can we generate reports in informatica ? How?
How can we join the tables if they don't have primary and foreign key relationship and no matching port? Name 4 output files that informatica server creates during session running? What is the functionality of update strategy? What are the different tasks that can be created in workflow manager? What are the new features of informatica 7.1? Explain the flow of data in Informatica? Explain one complicated mapping? what are the real time problems generally come up while doing or running mapping or any transformation? What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ? what is the difference between Informatica 7.1 and Ab Initio? What is Micro Strategy? Why is it used for? Two relational tables are connected to SQL Trans,what are the possible errors it will be thrown? what are cost based and rule based approaches and what is the difference? what is mystery dimension? Explain about the concept of mapping parameters and variables ? Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i? Can you generate reports in Informatcia? If you done any modifications for a table in back end does it reflect in informatca warehouse or mapping? How to recover sessions in concurrent batches? Explain about perform recovery? What are Dimensions and various types of Dimensions? What is Code Page Compatibility? What are Target Options on the Servers? What is tracing level and what are the types of tracing level?
What are the types of metadata that stores in repository? Define informatica repository? Can you copy the session to a different folder or repository? What is aggregate cache in aggregator transformation? what is a time dimension? give an example? Discuss the advantages & Disadvantages of star & snowflake schema? What is the difference between Normal load and Bulk load? What is the procedure to load the fact table.Give in detail? What is the use of incremental aggregation? why dimension tables are denormalized in nature ? What is the difference between Power Center and Power Mart? what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version? what is the exact meaning of domain? How do you handle decimal places while importing a flat file into informatica? What is data merging,data cleansing,sampling? How to import oracle sequence into Informatica? what is worklet and what use of worklet and in which situation we can use it? what happens if you try to create a shortcut to a non-shared folder? If you want to create indexes after the load process which transformation you choose? Where is the cache stored in informatica? what is Partitioning? where we can use Partition? what are the different types of transformation available in informatica and what are the mostly used what is surrogate key?In your project in which situation u has used?explain with example? HOW TO GET DUPLICATE RECORDS ARE ONE TABLE AND OTHER ARE ANOTHER TABLE
why sorter transformation acts as a active transformation What is data sampling in informatica How many Integration Service does Informatica Server contain? what is optimization in informatica what is pushdown optimization in informatica what is data model in data warehouse what is latest version of informatica power center What is Sql override and lookup override How to update a target table without primary key in informatica how do you read xml files in informatica In Real Time what are the scenarios u faced, what r the tough situations u have faced in ur job generally how many fact and dimension tables the banking project contains? please send me what are homogeneous sources and heterogeneous sources in informatica What is the Architecture of informatica How to create a session in informatica what is the real scenario to use sql transformation ? How to create a source definition in informatica What is the role of integration services in informatica What is SCD(slowly changing dimensions) in informatica and types of SCD what is dense rank in informatica What is mapplet and types of mapplets What is worklet or worklets in informatica and use? What is precision and scale in informatica what is bottleneck in informatica?
How to identify the bottlenecks in informatica How to eliminate/remove bottlenecks in informatica What is custom transformation in informatica What are the types of loading in informatica What are decode function in informatica what are the dimension and fact tables used in finance domain what is staging area in informatica i want to sample mappings,dimension and fact tables for banking project on informatica What is active transformation What are Additive facts why informatica What are Fact And Fact Table Types what is junk dimension with example Why and when we use snowflake schema What are Semi-Additive facts What are Non-Additive facts what is look up mapplet? How do you handle two sessions in Informatica What is intermediate task in informatica? In what situation this task will be executed? How to filter first or last 10 records using filter transformation? what is sort key how it functions how to create materialized view COMMON INTERVIEW QUESTIONS AND ANSWERS
why do you want to work for us?
Why do you consider yourself suitable for this post? what is your greatest strength
Why Do You Want To Work At Our Company? What motivates you,Money or Success ? why you choose our company? what is your job strength ? what is your ability? briefly describe your ideal job? what are your short term goals? Why do you think you are the best for this post? why u want to join this company? Tell me something about your self Why should we hire you? What Are your strengths and weaknesses? where do you see yourself in five(5) or ten(10) years from now? Why did you leave your (current)present/previous job/Company? what exactly do you look for a job? what is your expected salary how to impress the interviewer? Describe any happy moment in your life? What is your philosophy of life? Why we should not hire you? Why,you would like to join this organization?
What goals do you have in your career what makes you stand out among other candidates? Tell us about a time when you failed to meet a deadline. What were the repercussions? If you get a Opportunity to go with a reputed company which is ready to pay more than what we r going to pay here.Will you quit the job from here or what? Can you work well under deadlines or pressure?How? what is your goal of life? WHAT IS YOUR SALARY EXPECTATION? why do you want to work here? what is your memorable day tell me about your ideal person and why?
What would be your advantage in the future if you join now? How much salary do you want? What types of people do you get along with and why. Why did you choose this career? How do you plan to achieve these goals? how do you manage your stress Why do you think you do well? What are things most important to you in your job? What do you love and hate? tell me some thing about global warming what kind of salary are you looking for? What is your favorite past time? How do you see yourself?
Describe how your experience, qualifications and competencies match the position for which you are applying What is more important to you: the money or the work? why did you apply for this job What is your future Plans? Why You Are Looking For A New Job What job would you like to have in five years time? what will you do if you dont get this job What motivates you to do a good job? Sometimes a person younger to you might be in a better position.Are you comfortable taking directions from him? Describe yourself as a third person? what is the best way to start with the interview what are the challenges you faced in previous job? Tell me a situation you solve with creativity tell about your favorite game What have you learned from your previous jobs? Describe your work ethic? Why have you chosen the role you are applying for? who is your inspiration and why Briefly describe your duties and accomplishments What is your greatest achievement? Do you consider yourself successful? Give me an example of any major problem you faced and how you solved it What is your most significant experience? how will u design a pipe
Explain how you would be an asset to this organization Speak about city where you live What would you consider as your biggest achievement and why? Tell me about a time when you were able to identify a problem and resolve it before it became a major issue How long do you think it would be before you will make a significant contribution to the team/company? what do u preffer to be after 3years? Tell me something about your happiest day of your life. how can we justify yourself that you are fit for this job? AT WHAT YOU ARE THE BEST? What job position/s are you currently holding with your current employer? describe a difficult situation? tell about your most memorable movement How would you spend a million pounds? Tell me something about your worst day of your life. How would you describe your ideal job?As per my interest so that I can work with full devotion and can fulfill my professional ethics. why are you interested in our company. tell me about a situation when your work was criticized?
what is your ideal boss? Why cannot you clear the ijp(internal job posting) what attracted you to this position? what about your job profile can u speak around for 5mins about {Bangalore/any} city? What inspires you
tell something about your father? Tell me about your family background. What will be your expected Salary? Can you justify your Salary? what is your career aspect & if they asked in general what should i answer? What are your strengths and areas of improvement? how long do you think you would want to be in the employment of the organization? what is positive and negative in you? what influenced you to choose this career?? Tell me about your dream job. what motivates you and de-motivates you What have you done to show initiative in your career? what is the negative & positive thing in you? How do you prioritize your personal matter over work? What is your principles and values in life Describe about your ideal company what was your toughest/hardest decision you ever had to make? what makes you the suitable candidate for this position Have you worked with other on team endeavors Tell me about how you have left a position better than you found it what is your passion in life?
When do you get angry? what makes you dissatisfied about your current job? what are you doing before this job
What do you consider as the biggest challenge you have encounter in the work place Please explain to us one conflict situation that you have experienced in your work life and how did you solve it why u want to come to lower pay scale
Tell me about an experience in which you had to use tact? Who are our major competitors and what differences do you notice in our products? How do you determine or evaluate success? According to your definition of success, how successful have you been so far? What activities have you done in the past? What kind of person are you? What is Your organizational structure? what job profile are you interested in? What were your greatest accomplishments and challenges? if you were hiring a person for this job,what would look for? As a MBA marketing student why do you want to pursue your career in banking sector How to describe our city(Hyderabad) in a topic round during the interview time? what is your dream vacation Why do you think you are a qualified candidate for the job? what are your hobbies? how could i rate my self about my knowledge in programming what is your name how would you relate your key competencies to this position? What is your career plan? what would you want to be paid. are you the right person for this job?
whats a prefect introduction
How do you handle pressures and deadlines and multi-tasking? how do you plan your typical day at work how to answer for gap between education and work what are your job responsibility in your place of work? tell me about Bangalore
what can you contribute to this company? How much do you expect if we offer you this position how do u rate yourself on the scale of one to ten? what is the expansion of Philips? how many degrees of comparisons in English and explain about it? how did u spend your yesterday?
suppose you are asked a question concerning salary expectation, how do you tackle that question?
what are you doing why do you want a change? in which field u r working now How are you different from others? dressing style for interview? What impact would you make in our organization? What is your aim how to give self introduction what is your weakness and why?
Describe yourself what is your edge from the other applicants? why would u like to choose this profession? What attracted you to this job? In your last job,what would be the one thing that your peers most disliked about you? What qualities do you think make someone successful in business? Give us details of your present Employment Status. How soon can you travel down to any location posted to? how can you hire me when i have no experience?but i have ability to work for your company in your opinion,how many these weaknesses be addressed? why should we give you this job? why you would like to be considered for this role how do you see yourself after two years from now why you have left this job? what are your current weaknesses? why do you think you are fit for this job,you don't have experience,i don't think you are fit for a job What do you expect for your salary?Is this negotiable? How would your friends describe you? what is your favorite personality Why are choosing this company instead of other company?
WRITE AT LEAST FOUR STRENGTHS how long will u work here what do you consider to be your most significant achievement?what difficulties did you encounter in realizing the achievement and how did you overcome them
how do you work under pressure and solve your problems why do you want to join us? How creative are you?Give an example. Why should you be given the job? What are the benefits of being a graduate of Associate of computer Studies? What courses have you liked most?Least? Why? What do you do in your spare time? who serves as your inspiration while working? how do you find your salary? Can you give an advice to those students who are technician,taking computer programs? What does "success" mean to you?
when the interviewer asks, what is the Architecture of your project what we have to answer... plz provide the answer with the example Tell me about your current job and responsibility Why did you left the previous organization what is the best dress code for interview what is faithfulness in your point of view Give me your Self introduction why do you fit for the job what you want to become in your life? can you briefly describe your current position, its duties , and responsibilities? what is your attitude towards adversity and temptation? what sort of things motivates you? Mention briefly organisation structure of the company indicating your position in the hierarchy and the levels above and below you
what examples can you give that emphasize your interest in this kind of work What shall i do if i do not like some people at my office place . how shall i handle this kind of situation ? how long would you like to stay with this company? how do you rate yourself as a professional? tips for successful interviews how did you spend your last weekend What is the difference between doing a good job and doing a great job? what is the best possible answer of "why do you want to change" How shall i react if i do not like some people in our office why do like to work with us what is your daily routine how can i explain my project How long would you expect to work for us if hired? what motivates you ,money or work? Could you please introduce yourself? What attributes can you bring to this position? what initiative you did in last company as you worked for 3 years? Hi, Recently i have resigned a job. what i have to tell for the new employer that if he asks why you have resigned your previous job.i have worked there for 10 months. WHY DO YOU WANT TO LEAVE YOUR PRESENT JOB? what value you will add to our company if you are selected why looking for job change within 6 months what makes you different from other candidates? WHAT IS THE DIFFERENCE BETWEEN HARD WORK AND SMART WORK?
what kind of salary do you need? Where do do you want to being five year? why are you leaving this position? how to perform first round in interview What are the values & beliefs that have guided your life so far and how do you see them influencing your future? what do you expect to learn from this job what motivates you to work hard? Please tell us briefly about a situation in your life when you have had to stretch yourself to meet a new situation or higher standards? give me directions on how to get here in this office from where you currently reside what would you do if your boss needs several things done at the same time? introduce your self did you leave your job voluntarily or were you fired? Why are you looking for a new position (if you are currently employed)? kind of cement kind of pipe kind of g.i sheet size of shuttering scaffolding pipe How do you feel about the same job or work in progress right now. what are challenges and benefits from effective communication in the workplace Mention briefly organisation structure of the company Why did you leave your earlier job without any new job in hand? What are your short term and long term career goals? what is personality What will you do if your senior officer do not mind your work ? what are some things about global warming how you spend your yesterday from morning to till evening?
