Informatica Interview Questions and Answers

100+ TOP Informatica Interview Questions & Answers

Informatica Interview Questions
Informatica Interview Questions

1. HOW CAN YOU RECOGNIZE WHETHER OR NOT THE NEWLY ADDED ROWS IN THE SOURCE ARE GETS INSERT IN THE TARGET?
In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range.

2. WHAT IS THE DIFFERENCE BETWEEN INFORMATICA 7.0 AND 8.0?
The basic diff b/w in between informatica 8.0 and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage concept

3. PERFORMANCE TUNING IN INFORMATICA?
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performa

4. DIFFERENCES BETWEEN NORMALIZER AND NORMALIZER TRANSFORMATION.
Normalizer: It is a transormation mainly using for cobol sources, it’s change the rows into coloums and columns into rows Normalization:To remove the retundancy and inconsitecy

5. WHAT IS THE TARGET LOAD ORDER?
You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica ser

6. DIFF BETWEEN STATIC AND DYNAMIC CACHE? AND PLEASE EXPLAIN WITH ONE EXAMPLE?
Difference between static and dynamic cache- Static- Once the data is cached , it will not change. example unconnected lookup uses static cache. Dynamic- The cache is updated as to reflect the upda

7. WHAT IS THE USE OF INCREMENTAL AGGREGATION? EXPLAIN ME IN BRIEF WITH AN EXAMPLE.
Its a session option. When the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incr

8. WHAT IS THE DIFFERENCE BETWEEN INFORMATICS 7X AND 8X AND WHAT IS LATEST VERSION?
Java Transformation available in the 8x version and it is not available in 7x version.

9. HOW DO WE DO UNIT TESTING IN INFORMATICA? HOW DO WE LOAD DATA IN INFORMATICA?
Unit testing are of two types 1. Quantitaive testing 2.Qualitative testing Steps. 1.First validate the mapping 2.Create session on themapping and then run workflow. Once the session

10. IS SORTER AN ACTIVE OR PASSIVE TRANSFORMATION? WHAT HAPPENS IF WE UNCHECK THE DISTINCT OPTION IN SORTER? WILL IT BE UNDER ACTIVE OR PASSIVE TRANSFORMATION?
Sorter is an active transformation. if you don’t check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table.

11. HOW THE INFORMATICA SERVER SORTS THE STRING VALUES IN RANK TRANSFORMATION?
When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order configured in session properties.

12. EXPLAIN ABOUT INFORMATICA SERVER ARCHITECTURE?
Informatica server,load manager/rs,data transfer manager,reader,temp server and writer are the components of informatica server. first load manager sends a request to the reader if the reader is ready

13. HOW CAN YOU CREATE OR IMPORT FLAT FILE DEFINITION IN TO THE WAREHOUSE DESIGNER?
You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer. When you drag the fl

14. HOW CAN YOU IMPROVE SESSION PERFORMANCE IN AGGREGATOR TRANSFORMATION?
One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level

15. WHAT IS THE DIFFERENCE BETWEEN STOP AND ABORT?
stop: _______If the session u want to stop is a part of batch you must stop the batch, if the batch is part of nested batch, Stop the outer most batch Abort:—- You can issue the abort comma

16. IN UPDATE STRATEGY TARGET TABLE OR FLAT FILE WHICH GIVES MORE PERFORMANCE? WHY?
Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file. As the

17. HOW MANY TYPES OF DIMENSIONS ARE AVAILABLE IN INFORMATICA?
There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema

18. WHAT IS DIFFERENCE B/W INFORMATICA 7.1 AND ABINITIO
There is a lot of diffrence between informatica an Ab Initio In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim In Ab Initio no scheduling option we can scheduled manual

19. WHEN WE CREATE A TARGET AS FLAT FILE AND SOURCE AS ORACLE. HOW CAN I SPECIFY FIRST ROWS AS COLUMN NAMES IN FLAT FILES.
Use a pre sql statement….but this is a hardcoding method…if you change the column names or put in extra columns in the flat file, you will have to change the insert statement

20. WHAT IS THE DIFFERENCE BETWEEN FILTER AND LOOKUP TRANSFORMATION?
1) Filter transformation is an Active transformation and Lookup is a Passive transformation 2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data

21. HOW DO YOU CONFIGURE MAPPING IN INFORMATICA
You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary.

22. HOW CAN WE USE PMCMD COMMAND IN A WORKFLOW OR TO RUN A SESSION?
in the command task there is a option pression. we can write appropriate command of pmcmd to run workflow.

23. WHAT ARE THE OUTPUT FILES THAT THE INFORMATICA SERVER CREATES DURING THE SESSION RUNNING?
Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log). It also creates an error log for error messages. These files will b

24. IN DIMENSIONAL MODELING FACT TABLE IS NORMALIZED OR DENORMALIZED? IN CASE OF STAR SCHEMA AND INCASE OF SNOW FLAKE SCHEMA?
In Dimensional modeling, Star Schema: A Single Fact table will be surrounded by a group of Dimensional tables comprise of de- normalized data Snowflake Schema: A Single Fact table will be surrounded b

25. DISCUSS THE ADVANTAGES & DISADVANTAGES OF STAR & SNOWFLAKE SCHEMA?
In a STAR schema there is no relation between any two dimension tables, whereas in a SNOWFLAKE schema there is a possible relation between the dimension tables.

26. HOW MANY TYPES OF FACTS AND WHAT ARE THEY?
There are Factless Facts:Facts without any measures. Additive Facts:Fact data that can be additive/aggregative. Non-Additive facts: Facts that are result of non-additon Semi-Additive Facts: Only

27. WHAT IS SOURCE QUALIFIER TRANSFORMATION?
SQ transformation is a transformation which is automatically generated to read data from source tables into informatica designer.

28. WHEN DO U USE A UNCONNECTED LOOKUP AND CONNECTED LOOKUP…. WHAT IS THE DIFFERENCE BETWEEN DYNAMIC AND STATIC LOOKUP…Y AND WHEN DO V USE THESE TYPES OF LOOKUPS (I.E. DYNAMIC AND STATIC)
In static lookup cache, you cache all the lookup data at the starting of the session. in dynamic lookup cache, you go and query the database to get the lookup value for each record which needs the loo

29. WHICH TASKS CAN BE PERFORMED ON PORT LEVEL (USING ONE SPECIFIC PORT)?
I think unconnected Lookup or expression transformation can be used for single port for a row.

30. HOW CAN U WORK WITH REMOTE DATABASE IN INFORMATICA? DID U WORK DIRECTLY BY USING REMOTE CONNECTIONS?
To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source

31. CAN ANYONE EXPLAIN ERROR HANDLING IN INFORMATICA WITH EXAMPLES SO THAT IT WILL BE EASY TO EXPLAIN THE SAME IN THE INTERVIEW?
Go to the session log file there we will find the information regarding to the session initiation process, errors encountered. load summary. so by seeing the errors encountered during the

32. WHAT IS DIFFERENCE BETWEEN IIF AND DECODE FUNCTION
You can use nested IIF statements to test multiple conditions. The following example tests for various conditions and returns 0 if sales is zero or negative: IIF( SALES > 0, IIF( SALES < 50, SALAR

33. DIFFERENCE BETWEEN RANK AND DENSE RANK?
Rank: 1 2<–2nd position 2<–3rd position 4 5 Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.

34. WHAT IS MEANT BY AGGREGATE FACT TABLE AND WHERE IS IT USED?
Basically fact tables are two kinds 1. Aggregated factable and Factless fact table. Agregated factable has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless factable will not have

35. WHAT IS THE DIFFERENCE BETWEEN CONSTRAIND BASE LOAD ORDERING AND TARGET LOAD PLAN
Constraint based load ordering example: Table 1—Master Table 2—Detail If the data in table1 is dependent on the data in table2 then table2 should be loaded first.In such cases to con

36. WHAT IS THE DIFFERENCE BETWEEN CONNECTED AND UNCONNECTED STORED PROCEDURES?
Unconnected: The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another

37. WHAT ARE MAIN ADVANTAGES AND PURPOSE OF USING NORMALIZER TRANSFORMATION IN INFORMATICA?
Narmalizer Transformation is used mainly with COBOL sources where most of the time data is stored in de-normalized format. Also, Normalizer transformation can be used to create multiple rows from a si

38. HOW CAN WE PARTITION A SESSION IN INFORMATICA?
The Informatica PowerCenter Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools redu

39. WHAT IS UPDATE STRATEGY TRANSFORMATION?
The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session.

40. WHEN DO U WE USE DYNAMIC CACHE AND WHEN DO WE USE STATIC CACHE IN AN CONNECTED AND UNCONNECTED LOOKUP TRANSFORMATION
We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the recor

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 into two (a

51. SCD MAPPINGS ARE MOSTLY USED UNCONNECTED LOOKUP TRANSFORMATION. UNCONNECTED LOOKUP USED STATIC CACHE ONLY. AT THIS TIME HOW CAN YOU INSERT OR UPDATE DATE IN TARGET BY USING STATIC CACHE?
There is no connected lookup t/r n by default it takes static cache.For insert n update operations we use dynamic cache.

52. WHAT ARE THE JOINER CACHES?
When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the ca

53. WHY DID U USE UPDATE STATEGY IN YOUR APPLICATION?
Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you w

54. WHAT IS DIFFERENCE BETWEEN PARTIONING OF RELATONAL TARGET AND PARTITIONING OF FILE TARGETS?
Partition’s can be done on both relational and flat files. Informatica supports following partitions 1.Database partitioning 2.RoundRobin 3.Pass-through 4.Hash-Key partitioning 5.Key

55. WHAT ARE THE NEW FEATURES OF THE SERVER MANAGER IN THE INFORMATICA 5.0?
You can use command line arguments for a session or batch.This allows you to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature

56. WHAT IS THE DIFFERENCE BETWEEN SUMMARY FILTER AND DETAIL FILTER?
Summary filter can be applieid on a group of rows that contain a common value.where as detail filters can be applied on each and every rec of the data base.

57. WHAT ARE THE CONNECTED OR UNCONNECTED TRANSFORMATIONS?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.

58. HOW TO IMPORT ORACLE SEQUENCE INTO INFORMATICA.
CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.

59. WHAT ARE THE REAL TIMES PROBLEMS GENERALLY COME UP WHILE DOING/RUNNING MAPPING/ANY TRANSFORMATION? CAN ANYBODY EXPLAIN WITH EXAMPLE.
Here are few real time examples of problems while running informatica mappings: 1) Informatica uses OBDC connections to connect to the databases. The database passwords (production ) is changed in

60. IF A SESSION FAILS AFTER LOADING OF 10,000 RECORDS IN TO THE TARGET. HOW CAN U LOAD THE RECORDS FROM 10001 THE RECORD WHEN U RUN THE SESSION NEXT TIME?
As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails.

61. WHY DID YOU USE STORED PROCEDURE IN YOUR ETL APPLICATION?
Usage of stored procedure has the following advantages 1 checks the status of the target database 2 drops and recreates indexes 3 determines if enough space exists in the database 4 perfor

62. WHAT ARE THE DIFFERENCE BETWEEN JOINER TRANSFORMATION AND SOURCE QUALIFIER TRANSFORMATION?
You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. You need matching keys to join two relational sources in source qualifier

63. EXPLAIN USE OF UPDATE STRATEGY TRANSFORMATION
This is the important transformation,is used to maintain the history data or just most recent changes into the target table. We can set or flag the records by using these two levels. 1) Within a ses

64. WHAT ARE THE DIFFERENCE BETWEEN VIEW AND MATERIALIZED VIEW?
Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. A materialized view provides indirect access to

65. IDENTIFYING BOTTLENECKS IN VARIOUS COMPONENTS OF INFORMATICA AND RESOLVING THEM.
The best way to find out bottlenecks is writing to flat file and see where the bottle neck is .

66. WHAT ARE THE BASIC NEEDS TO JOIN TWO SOURCES IN A SOURCE QUALIFIER?
Basic need to join two sources using source qualifier: 1) Both sources should be in same database 2) The should have at least one column in common with same data types

67. THIS IS A SCENARIO IN WHICH THE SOURCE HAS 2 COLS 10 A 10 A 20 C 30 D 40 E 20 C AND THERE SHOULD BE 2 TARGETS ONE TO SHOW THE DUPLICATE VALUES AND ANOTHER TARGET FOR DISTINCT ROWS. T1 T2 10 A 10 A 20 C 20 C 30 D WHICH TRANSFORMATION CAN BE USED TO LOAD DATA INTO TARGET? 40 E

Sorter Transformation to Target 2. Source qualifier transformation to Target 1. Check the Distinct option in Sorter transformation.

68. WHAT ARE TWO MODES OF DATA MOVEMENT IN INFORMATICA SERVER?
The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and cod

69. WHAT IS PUSHDOWN OPTIMIZATIONS IN PC 8.X WITH EXAMPLE?
Use pushdown optimization to push transformation logic to the source or target database. The Integration Service analyzes the transformation logic, mapping, and session configuration to determine the

70. I HAVE WINDOWS XP. I WAS TOLD A PERSON COULD FIND OUT WHAT SITES A PERSON IS LOOKING ON YOUR COMPUTER. HOW DO YOU DO THIS? I HAVE A PERSON WHO USES MY COMPUTER, AND I THINK HE IS LOOKING AT SITES HE SHOULD NOT BE VIEWING.

Open the browser, click the history button.

71. WHAT ARE THE TYPES OF MAPING IN GETTING STARTED WIZARD?
Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Gr

72. IN A SCENARIO I HAVE COL1, COL2, COL3, UNDER THAT 1,X,Y, AND 2,A,B AND I WANT IN THIS FORM COL1, COL2 AND 1,X AND 1,Y AND 2,A AND 2,B, WHAT IS THE PROCEDURE?
Use Normalizer : create two ports – first port occurs = 1 second make occurs = 2 two output ports are created and connect to target

73. HOW CAN YOU IMPROVE THE PERFORMANCE OF AGGREGATE TRANSFORMATION?
We can improve the aggregator performance in the following ways 1.send sorted input. 2.increase aggregator cache size. i.e. Index cache and data cache. 3.Give input/output what you need in th

74. WHERE TO STORE INFORMATICA REJECTED DATA? HOW TO EXTRACT THE INFORMATICA REJECTED DATA?
The reject rows say for example due to unique key constrain is all pushed by session into the $PMBadFileDir

75. IN A SEQUENTIAL BATCH HOW CAN WE STOP SINGLE SESSION?
We can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.

76. HOW DO YOU CREATE SINGLE LOOKUP TRANSFORMATION USING MULTIPLE TABLES?
Write a override sql query. Adjust the ports as per the sql query.

77. WHAT R THE MAPINGS THAT WE USE FOR SLOWLY CHANGING DIMENSION TABLE?
We can use the following Mapping for slowly Changing dimension table. Expression Lookup Filter Sequence Generator Update Strategy

78. IN WHICH CONDITIONS WE CANNOT USE JOINER TRANSFORMATION (LIMITATIONS OF JOINER TRANSFORMATION)?
Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transfo

79. WHAT IS BATCH AND DESCRIBE ABOUT TYPES OF BATCHES?
There are two types of batches 1. Concurrent 2. Sequential

80. WHAT IS THE PROCEDURE TO LOAD THE FACT TABLE? GIVE IN DETAIL?
Based on the requirement to your fact table, choose the sources and data and transform it based on your business needs. For the fact table, you need a primary key so use a sequence generator transfo

81. HOW TO MOVE THE MAPPING FROM ONE DATABASE TO ANOTHER?
1. Open the mapping you want to migrate. Go to File Menu – Select ‘Export Objects’ and give a name – an XML file will be generated. Connect to the repository where you want to migrate and then select.

82. HOW DO U CHECK THE SOURCE FOR THE LATEST RECORDS THAT ARE TO BE LOADED INTO THE TARGET. I.E. I HAVE LOADED SOME RECORDS YESTERDAY, TODAY AGAIN THE FILE HAS BEEN POPULATED WITH SOME MORE RECORDS TODAY, SO HOW DO I FIND THE RECORDS POPULATED TODAY.

a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port f

83. WHAT ARE VARIABLE PORTS AND LIST TWO SITUATIONS WHEN THEY CAN BE USED?
We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when

84. CAN YOU USE THE MAPING PARAMETERS OR VARIABLES CREATED IN ONE MAPING INTO ANY OTHER REUSABLE TRANSFORMATION?
Yes.Because reusable tranformation is not contained with any maplet or maping.

85. PARTITIONING, BITMAP INDEXING (WHEN TO USE), HOW WILL THE BITMAP INDEXING WILL EFFECT THE PERFORMANCE
Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm

86. HOW A TWO DIMENSION ARRAY IS INITIALIZE WITH POINTER?
#include void main() { int size; cout<<“Size “; cin>>size; int **p=new int *[size.; for(int i=0;i

87. WHAT R THE TYPES OF GROUPS IN ROUTER TRANSFORMATION?
A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output

88. THERE ARE 1000 SOURCE TABLES CONTAINING THE SAME DATA WITH DIFFERENT FILE FORMATS, NOW I WANT TO LOAD INTO A SINGLE TARGET TABLE. HOW TO ACHIEVE ?
first u should convert diff. file format to one format then create 1 to 1 mapping,run it and see the o/p in unix whether file is posted or not.

89. HOW CAN U COMPLETE UNRECOVERABLE SESSIONS?
Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica S

90. HOW U WILL CREATE HEADER AND FOOTER IN TARGET USING INFORMATICA?
If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties

91. HOW CAN YOU SAY THAT UNION TRANSFORMATION IS ACTIVE TRANSFORMATION?
By Definition, Active transformation is the transformation that changes the number of rows that pass through it…in union transformation the number of rows resulting from union can be (are) different

92. WHAT IS THE DIFFERENCE BETWEEN POWERCENTER 6 AND POWERCENTER 7?
1)lookup the flat files in informatica 7.X but we cann’t lookup flat files in informatica 6.X 2) External Stored Procedure Transformation is not available in informatica 7.X but this transformation

93. WHAT ARE LOAD TYPES IN INFORMATICA AND WHAT IS DELTA LOAD
There are two types of load bulk and normal.we ll use normal type almost, bulk is used in for the data which is huge to insert to the target

94. HOW CAN I TRANSFORM ROW TO COLUMN?
Through Normalizer Transformation we can do this.

95. 1. CAN U EXPLAIN ONE CRITICAL MAPPING? 2. PERFORMANCE ISSUE WHICH ONE IS BETTER? WHETHER CONNECTED LOOKUP TRANSFORMATION OR UNCONNECTED ONE?
it depends on your data and the type of operation u r doing. If u need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup. Or,i

96. DIFFERENCE BETWEEN STATIC CACHE AND DYNAMIC CACHE
Static cache Dynamic cache U can not insert or update the cache U can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache w

97. WHAT IS TRANSACTION?
Transaction is a logical unit of work that comprises one or more sql statements executed by a single user

98. WHAT IS THE DIFFERENCE BETWEEN NORMAL LOAD AND BULK LOAD?
Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in su

99. WHY SORTER TRANSFORMATION IS AN ACTIVE TRANSFORMATION?
This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes pl

100. WHAT IS THE LOGIC WILL YOU IMPLEMENT TO LOAD THE DATA IN TO ONE FACTV FROM ‘N’ NUMBER OF DIMENSION TABLES.
Normally every one use 1) slowly changing dimensions 2) slowly growing dimensions.

Real Time Informatica Interview Questions