FPT Software Informatica Administrator Interview Questions and Answers

Q1. About technical operations .
Add your answer
Q2. What is your experience with Microsoft 365 and its documentation features?
Add your answer

Q1. Can you describe your past work experiences?
Add your answer
Q2. Your skills.
Add your answer

Q1. Analytical functions difference
Ans. 
Analytical functions are used to perform calculations across a set of rows related to the current row.
• Analytical functions operate on a group of rows and return a single result for each row

• They can be used to calculate running totals, moving averages, rank, percentiles, etc.

• Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
Answered by AI
Add your answer
Q2. Which transformation uses in scd2?
Ans. 
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
• SCD2 transformation is used to track historical changes in dimension tables.

• It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.

• Commonly used in scenarios where historical data needs to be preserved and queried.

• Example: When a c...read more
Answered by AI
Add your answer
Q3. Unix basic, how to find particular file in directory?
Add your answer
Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
Ans. 
To find the count of different types of joins between two tables A and B.
• Left join: Includes all records from table A and matching records from table B.

• Right join: Includes all records from table B and matching records from table A.

• Inner join: Includes only the matching records from both tables.

• Full outer join: Includes all records when there is a match in either table A or table B.
Answered by AI
Add your answer
Q5. Incremental load
Add your answer

Q1. Data warehouse concept
Add your answer
Q2. Linux commands like sed ,grep,find
Add your answer
Q3. Diff between char and varchar
Ans. 
Char is fixed length string data type, while varchar is variable length string data type.
• Char stores fixed length strings, while varchar stores variable length strings.

• Char pads with spaces to reach fixed length, while varchar does not pad.

• Char is faster for fixed length data, while varchar is more flexible for variable length data.
Answered by AI
Add your answer
Q4. How to connect the session using unix
Ans. 
To connect a session using Unix, you can use the pmcmd command with appropriate arguments.
• Use the pmcmd command followed by the connect option to connect to the Informatica session.

• Provide the necessary connection details such as domain, repository, username, and password.

• You can also specify the session name and folder path if needed.

• Example: pmcmd connect -sv MyInformaticaServer -d MyDomain -u MyUsername -p MyPasswor
Answered by AI
Add your answer

Q1. Sql/ data warehousing/ scenario based questions
Add your answer
Q2. Explain Daily work in detail
Add your answer
Q3. Google-informatica scenario based questions
Add your answer
Q4. Sql- 2nd highest or 3rd highest salary
Ans. 
To find the 2nd or 3rd highest salary in SQL, use the 'ORDER BY' and 'LIMIT' clauses.
• Use the 'ORDER BY' clause to sort the salaries in descending order.

• Use the 'LIMIT' clause to specify the number of rows to return.

• For 2nd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

• For 3rd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2,1
Answered by AI
Add your answer

Q1. Salary negotiation
Add your answer

Q1. What is filter transformation
Ans. 
Filter transformation is used to filter rows from a data source based on specified conditions.
• Filter transformation is an active transformation in Informatica PowerCenter.

• It allows you to define conditions to filter rows from the source data.

• Rows that meet the filter conditions are passed to the next transformation, while others are dropped.

• Filter transformation can be used to eliminate unwanted data or select specific...read more
Answered by AI
View 1 more answer
Q2. Difference between connected and unconnected lookup
Ans. 
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
• Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.

• Connected lookup receives input values directly from the pipeline, while unconnected lookup receives input values from the calling transformation.

• Connected lookup returns a value to the pipeline, while unconnected ...read more
Answered by AI
Add your answer
Q3. Diff between active and passive transformation
Ans. 
Active transformations change the number of rows that pass through it, while passive transformations do not.
• Active transformations change the data stream by adding, deleting, or modifying rows

• Passive transformations do not change the data stream, but may change the data within the stream

• Active transformations include Filter, Router, Update Strategy, and Expression

• Passive transformations include Aggregator, Joiner, Look
Answered by AI
Add your answer
Q4. How to improve performance
Add your answer
Q5. What is pushdown automata
Ans. 
Pushdown automata is a type of automata that can recognize context-free languages.
• Pushdown automata is a theoretical model of computation.

• It has a stack that can be used to store and retrieve information.

• It is used to recognize context-free languages.

• It is more powerful than finite automata but less powerful than Turing machines.

• Examples of context-free languages include arithmetic expressions and programming languages
Answered by AI
Add your answer
Q6. How to update table without using update startegy
Ans. 
Use SQL merge statement to update table without update strategy
• Use SQL merge statement to update table

• Specify the source and target tables

• Define the join condition

• Specify the columns to update

• Use WHEN MATCHED THEN UPDATE statement

• Use WHEN NOT MATCHED THEN INSERT statement
Answered by AI
Add your answer

More on informatica and SQL code

Q1. Nothing difficult just discuss about pay scale
Add your answer

Q1. Diff between powercenter and IICS
Ans. 
PowerCenter is an on-premise data integration tool, while IICS is a cloud-based integration platform.
• PowerCenter is on-premise, IICS is cloud-based

• PowerCenter is a traditional ETL tool, IICS is a modern integration platform

• PowerCenter requires infrastructure setup, IICS is managed by Informatica

• PowerCenter is more suitable for large enterprises with on-premise data, IICS is better for cloud-based integrations
Answered by AI
Add your answer
Q2. Types of caches
Ans. 
Types of caches include memory cache, disk cache, and browser cache.
• Memory cache stores data in memory for quick access.

• Disk cache stores data on the hard drive for faster retrieval.

• Browser cache stores web page elements to reduce loading times.

• Other types include CPU cache, page cache, and object cache.
Answered by AI
Add your answer

Q1. Questions related to informatica powercenter basic to mid level
Add your answer

Q1. Self intro as usual
Add your answer
Q2. What are active and passive transformations?
Ans. 
Active transformations change the number of rows that pass through them, while passive transformations do not change the number of rows.
• Active transformations can filter, update, or modify the number of rows in a data stream (e.g. Filter, Router, Update Strategy).

• Passive transformations do not change the number of rows in a data stream, they only allow data to pass through unchanged (e.g. Expression, Lookup, Sequence G
Answered by AI
Add your answer
Q3. Some basic questions on transformations like Expression, Update, Router, filter, SQ,lookup etc
Add your answer
Q4. What are different types of lookup caches
Ans. 
Different types of lookup caches include persistent cache, dynamic cache, and shared cache.
• Persistent cache stores lookup data in a flat file or database table for reuse across sessions.

• Dynamic cache dynamically loads lookup data into memory as needed during a session.

• Shared cache allows multiple sessions to share the same cache for improved performance.
Answered by AI
Add your answer
Q5. Difference between filter and router.
Ans. 
Filter is used to pass or reject data based on conditions, while router is used to route data to different targets based on conditions.
• Filter is used to include or exclude data based on specified conditions.

• Router is used to direct data to different targets based on specified conditions.

• Filter is typically used to remove unwanted data, while router is used to split data flow.

• Example: Using filter to exclude records wit...read more
Answered by AI
Add your answer

Q1. Some basic to medium level questions on transformations
Add your answer
Q2. Some real time scenario questions
Add your answer
Q3. Direct and indirect file loading
Add your answer

Q1. Asked for Mumbai location
Add your answer
Q2. 5 days Client office
Add your answer

Q1. Questions related to transformation s
Add your answer
Q2. Questions of unix
Add your answer

Q1. Adavanced topic of informatica
Add your answer
Q2. SQL queries questions
Add your answer