tag:blogger.com,1999:blog-83318760826430622762024-03-09T18:45:46.960-08:00INFORMATICA INTERVIEW QUESTIONSINFORMATICA INTERVIEW QUESTIONShttp://www.blogger.com/profile/12685042418418004339noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8331876082643062276.post-68827734760060673522015-12-22T01:46:00.000-08:002021-02-17T12:02:41.932-08:00INFORMATICA INTERVIEW QUESTIONS<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "verdana" , sans-serif;"><b>Informatica Interview Questions PART-I</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;"><b>1. What is Data Model?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;">A data model is a database design which describes tables and relationships with in the </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">database. Data model helps in organizing the data in an efficient manner.There are three </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">different phases in data modeling. </span><br />
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><b>a) Conceptual Data Modeling:</b> This is the first phase of the data modeling. After analyzing FSD </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">and BRD we identify the list of entities and relationships between them. No attributes and keys </span><span style="font-family: "verdana" , sans-serif; text-align: left;">are defined in this phase.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><b>b) Logical Data Modeling:</b> This is the second phase of the data modeling. In this phase we </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">define attributes for entities and keys in each entity i.e includes primary key and foreign </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">keys. In this phase we go for approvals from Data Architect Team. </span><br />
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><b>c) Physical Data Modeling:</b> This is the third phase of the data modeling. In this phase we </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">define table names, column names, data types, constraints etc according the standards. We use </span><span style="font-family: "verdana" , sans-serif; text-align: justify;">this model to create database objects in the database.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>2. Which Data Model is used in Data Warehousing Projects?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Dimensional modeling is used in data warehousing projects. Dimensional modeling includes star </span><span style="font-family: "verdana" , sans-serif;">schema, snow flake schema and hybrid schema. Hybrid schema includes combination of star and </span><span style="font-family: "verdana" , sans-serif;">snow flake schema. All these schema's contains dimension tables and fact tables. Relationships </span><span style="font-family: "verdana" , sans-serif;">exist between dimension tables and fact tables.</span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">In Data warehousing projects we use different types of data modeling tools. </span><br />
<span style="font-family: "verdana" , sans-serif;">Eg:- Erwin, Open </span><span style="font-family: "verdana" , sans-serif;">Model Sphere, Model Right etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>3. What is star schema?</b> </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Star Schema is a Dimensional Model, centrally located fact table surrounded by multiple </span><span style="font-family: "verdana" , sans-serif;">dimension tables. In this schema, each dimension table has its own primary key. Fact tables </span><span style="font-family: "verdana" , sans-serif;">contain primary keys, and foreign keys from each dimension table.</span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The main advantages of star schema are:</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a) Easy To Understand: Relationships between dimension and fact are based on primary and </span><span style="font-family: "verdana" , sans-serif;">foreign keys.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">b) High Performance: In order to get relevant data for the business reports, need to join only dimensions and facts, leads to less number of joins.</span><br />
<div>
<br /></div>
<span style="font-family: "verdana" , sans-serif;"><b>4. What is snow flake schema?</b></span><br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Snow Flake schema is similar to star schema except that there is a hierarchical relationship </span><span style="font-family: "verdana" , sans-serif;">between dimension to dimension. Snow flake schema also contains dimensions and facts. Data is </span><span style="font-family: "verdana" , sans-serif;">normalized in snow flake schema, which leads to occupy less space in the database. Compare to </span><span style="font-family: "verdana" , sans-serif;">star schema, snow flake schema performance is low, need to join more number of tables in order </span><span style="font-family: "verdana" , sans-serif;">to get relevant data for business reports.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>5. What is dimension and fact?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">A dimension represents descriptive information or textual information. The data modeler identifies attributes which are come under dimension table. Common examples for dimension tables </span><span style="font-family: "verdana" , sans-serif;">are customer, time and product etc. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">A fact represents numeric or numbers. Every numeric or number is not a fact. A numeric value </span><span style="font-family: "verdana" , sans-serif;">which is used for business analysis is considered as a fact. For example customer number is not </span><span style="font-family: "verdana" , sans-serif;">a fact even though it is number. Quantity is a fact, we can do business analysis on this, how </span><span style="font-family: "verdana" , sans-serif;">much quantity sold in a particular location, how much quantity sold in a particular year etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b style="font-family: verdana, sans-serif;">6. When we go for star and when we go for snow flake schema?</b></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">In general in DWH projects we prefer to use Star Schema only. Star schema is a powerful design in performance consideration. We go for snow flake schema in DWH projects in below cases.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">a) Database Space is a constraint: Data is normalized in snow flake schema, so less chance of data redundancy leads to occupy less space.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">b) No.of columns in the table are more than 500: If the number of columns are huge in a table, the retrieval speed is less. To overcome this we split columns into multiple tables.</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>7. What is data purging?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Data purging is the process of deleting data from the data warehouse. Based on business requirement we maintain 5 or 7 or 10 years of data in DWH dimension and fact tables, before that data we delete data from dimensions and fact tables. We create separate mappings to purge or delete data from dimensions and facts. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">These mappings we schedule yearly once to delete old data. Based on key columns we delete data from dimensions and facts along with update strategy transformation. Data purging process helps to delete unnecessary data from the DWH and leads to performance efficiency.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>8. What is data Cleansing and data merging?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Data cleansing means removing unwanted data or inconsistent data. For example you have a table Employee and column is city, values are coming different ways from different source systems</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">S1- Hyd S2- hyd S3- Hyderabad S4-hyderabad S5- HYDERABAD</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">In DWH we maintain all values as "HYDERABAD" based on business decision. We convert S1- Hyd value to HYDERABAD, </span><span style="font-family: "verdana" , sans-serif;">S2- hyd value to HYDERABAD, </span><span style="font-family: "verdana" , sans-serif;">S3- Hyderabad value to HYDERABAD and S4-hyderabad value to HYDERABAD.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Data merging means combining data from multiple source systems. We use join and union operations to perform this. In order to join two sources, you should have at least one common column. In order to use Union you should have same no.of columns an data types in both the sources.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Join: Column level concatenation</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Union: Row level concatenation</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>9. What is data Scrubbing?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Data Scrubbing means deriving new column values based on existing existing column values. For example in an employee table we have columns eno, ename, sal coming from the source, need to calculate tax based on salary, but tax is not coming from the source, we are deriving the value tax, this operation is known as data scrubbing.</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you want to know more Data Warehouse Questions, see the below video</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<u style="color: #0000ee; font-family: Verdana, sans-serif;"><a href="https://youtu.be/3-kZaJOtcfs">https://youtu.be/3-kZaJOtcfs</a></u></div>
<div style="text-align: justify;">
<b style="font-family: Verdana, sans-serif;"><br /></b>
<b style="font-family: Verdana, sans-serif;">10. What is data mart?</b></div>
<div style="text-align: justify;">
<br />
<span style="font-family: "verdana" , sans-serif;">A data mart is a subset of enterprise data warehouse, at any point of time it contains only one subject or department information. If it contains sales information then we call it as sales data mart, if it contains IT information then we call it as IT data mart, if it contains finance information then we call it as finance data mart. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">There are many advantages of creating data mart</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a) Requirements gathering is simple, if you want construct only sales data mart you need to connect only with sales people</span><br />
<span style="font-family: "verdana" , sans-serif;">b) It takes less time to build, 6 to 9 months</span><br />
<span style="font-family: "verdana" , sans-serif;">c) The security is high, if you construct sales data mart, you are providing access to only sales people</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b style="font-family: Verdana, sans-serif; text-align: left;">11. What is aggregator transformation?</b></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Aggregator transformation is an active transformation and its connected, mainly used to perform calculations on group of rows. </span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">For example in each department we have several employees. In order to know how much salary we are paying for each department then first we group the rows based on department number and then we use sum() aggregate function.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>12. What is the default behavior of aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The default behavior of aggregator transformation is last row from each group. If the data contains 3 different groups then from each group it returns last row, total 3 rows as output. Once all rows entered into aggregator then it groups the rows.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>13. What happens if you don't select group by ports in aggregator?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you don't select any group by ports in aggregator transformation, by default it treats all rows as single group and returns last row. For example if you send 1 million rows as input to aggregator, the output is only 1 row i.e last row. When you double click on aggregator transformation it opens a dialogue box, select ports tab, under this tab you can select group by ports.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>14. What happens if you select all group by ports in aggregator?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you select all ports as group by ports in aggregator, it applies grouping on all ports and eliminates duplicate records. In grouping it consider all ports, if all ports are same then it will treat as a single group.</span></div>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<span style="font-family: "verdana" , sans-serif;">Eg:- </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Input:</span><br />
<span style="font-family: "verdana" , sans-serif;"> ENO NAME SAL</span><br />
<span style="font-family: "verdana" , sans-serif;"> 100 RAVI 2000</span><br />
<span style="font-family: "verdana" , sans-serif;"> 100 RAVI 2000</span><br />
<span style="font-family: "verdana" , sans-serif;"> 101 VINAY 3000</span><br />
<span style="font-family: "verdana" , sans-serif;">Output:</span><br />
<span style="font-family: "verdana" , sans-serif;"> </span><span style="font-family: "verdana" , sans-serif;">ENO NAME SAL</span><br />
<span style="font-family: "verdana" , sans-serif;"> </span><span style="font-family: "verdana" , sans-serif;">100 RAVI 2000</span><br />
<span style="font-family: "verdana" , sans-serif;"> 101 VINAY 3000</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>15. What are different types of caches in aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">There are two different types of caches in aggregator transformation. By default the cache values stored under directory $PMCacheDir</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">a. Index Cache ==> Contains Group by Ports Information</span><br />
<span style="font-family: "verdana" , sans-serif;">b. Data Cache ==> Contains Aggregated Calculation Ports Information</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Index Cache file has extension .idx</span><br />
<span style="font-family: "verdana" , sans-serif;">Data Cache file has extension .dat</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>16. What are different types of aggregate functions in aggregator?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Following are the different types of aggregate functions available in informatica power center tool.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">a. Sum()</span><br />
<span style="font-family: "verdana" , sans-serif;">b. Max()</span><br />
<span style="font-family: "verdana" , sans-serif;">c. Min()</span><br />
<span style="font-family: "verdana" , sans-serif;">d. Avg()</span><br />
<span style="font-family: "verdana" , sans-serif;">e. First()</span><br />
<span style="font-family: "verdana" , sans-serif;">f. Last() etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>17. What are conditional statements in aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The conditional statements you can include in the aggregate function itself. While performing aggregate calculations, we can use conditional statements with the help of IIF.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Eg:- SUM(IIF(CITY='HYDERABAD',SAL,0))</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">The above example calculates only HYDERABAD city employees total.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>18. What are nested aggregate functions in aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you place one aggregate function in another then it is called nesting of aggregation. If you want to use incremental aggregation, you should not use nested aggregate functions.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Eg:- MAX(SUM(SAL))</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The above example returns which department is paying highest salaries. Inner function calculates how much salary we are paying for each department.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>19. What happens if group by port contains null values in aggregator?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">All rows containing null values will treat as separate group and the aggregator transformation returns last row from that group.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b style="text-align: left;">20. Can you create a variable port in aggregator?</b></span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Yes we can create variable ports in aggregator transformation. Generally we define variable ports for temporary calculations, which are used in other output ports calculations. </span></div>
<br />
<span style="font-family: "verdana" , sans-serif;">All above information you can see in below video with examples</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><a href="https://www.youtube.com/watch?v=SS0-XdluF1Q">https://www.youtube.com/watch?v=SS0-XdluF1Q</a></u></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>21. What are the optimization techniques in aggregator transformaion?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">There are two optimization techniques in aggregator transformation to improve the performance.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">a. Sorted Input</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">b. Incremental Aggregation</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>22. How to set sorted input option in aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Sorted Input option available under properties tab of aggregator transformation. When you select this option you need to send the sorted data to the aggregator. You need sort group by ports before sending data to the aggregator. For example if you take DNO is the group by port then you need to sort on DNO.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>23. How sorted input helps in increasing performance of aggregator transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">When we sort the data and send to aggregator, then immediately performs aggregate calculations. It won't wait till all rows entered into aggregator. Informatica can't read all rows at a time, it will read block by block. If you don't select sorted input, aggregator will wait till all rows entered into aggregator.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>24. What is incremental aggregation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Incremental aggregation means aggregating values based on existing aggregated values. Below example clarifies.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">First time we received below rows from source.</span><br />
<span style="font-family: "verdana" , sans-serif;">eno name sal dno</span><br />
<span style="font-family: "verdana" , sans-serif;">100 ravi 2000 10</span><br />
<span style="font-family: "verdana" , sans-serif;">101 vinay 3000 10</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Ouput :- 10 5000</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Next time new employee added in same department</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">102 raju 4000</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">this time when you use incremental aggregation it performs 5000+4000 instead of again adding all employee salaries 2000+3000+4000</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>25. When cache files deleted for incremental aggregation what happens?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">When cache files not available in informatica server, then session won't fail, it will recreate the cache automatically. But it takes more time compared to normal run, reason is recreation of cache takes some time.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>26. Can we select both sorted input and incremental aggregation at a time?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">No, we can't select. Reason is if you select sorted input it performs calculations in memory. When you select incremental aggregation it performs calculations on existing cache values. </span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>27. Where cache files stored?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">All the cache files by default stored under server<b>/infa_shared/cache</b> directory. You can change the default directory value also by assigning some other directory.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>28. When cache files will be deleted?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Automatically cache files will be deleted after session succeeded. No need of manual intervention. </span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>29. Cache files will be deleted if session fails?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If session fails, cache files won't delete, we need to manually delete. Connect to informatica server and then go to the cache directory and then apply rm command in unix/linux.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>30. How to get first and last record using aggregator?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">By default you can get last record from aggregator, to get first record use First() function for each port. Source, SQ, two aggregators, by default one aggregator returns last row connect to one target isntance, another aggregator select first() function on each port and connect to other target instances.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>31. What is a transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">A transformation is a repository object that generates, modifies and produce output. The transformations are generally used to implement different types of business logic.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>32. What are different types of transformations?</b></span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">There are two different types of transformations available in informatica power center tool.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a) Active: Number of input rows<>Number of output rows</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">b) Passive: Number of input rows=Number of output rows</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>33. What is the difference between active and passive transformations?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;">A transformation is said to be active if the number of rows pass through that transformation can change. For example if you send 5 rows as input to that transformation, the output may be less than 5 or more than 5 rows.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: justify;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: justify;">Examples for active transformations are: aggregator, filter, router, rank, sorter, normalizer, joiner, update strategy, source qualifier etc.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">A transformation is said to be passive if the number of rows pass through that transformation can't change. For example if you send 5 rows as input to that transformation, the output also 5 rows.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Examples for passive transformations are: expression, stored procedure, sequence generator etc.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>34. When we go for expression transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">We use expression transformation to perform calculations on each and every row. For example to calculate tax and net salary for each and every employee.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>35. When we go for aggregator transformaion?</b></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We use aggregator to perform calculations on group of rows. For example in order to find out the total amount of salary paying for each department, then we use sum() aggregate function. For example if you want to know who is taking highest salary from each department then we use max() aggregate function.</span></div>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<span style="font-family: "verdana" , sans-serif;"><b>36. What is the difference between expression and aggregator?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Expression transformation is passive and aggregator transformation is active. Expression is used to perform calculations on each and every row where as aggregator is used to perform calculations on group of rows.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>37. What is the difference between filter and router?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Filter transformation supports single condition, where as router transformation supports multiple conditions by creating multiple groups. You cannot capture rejected records in filter, where as in router you can capture rejected records using default group.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>38. What is ETL?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span>
</div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">See the below link you can get more information (definition, tools and different types of jobs on etl tools) on this question </span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><a href="https://youtu.be/3-kZaJOtcfs">https://youtu.be/3-kZaJOtcfs</a></u></span><br />
<span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><br /></u></span></div>
<div style="text-align: justify;">
<b style="font-family: Verdana, sans-serif;">39. How do you justify sorter is an active transformation?</b></div>
<div style="text-align: justify;">
<b style="font-family: Verdana, sans-serif;"><br /></b></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We can eliminate duplicate records using distinct option under properties tab of sorter transformation. For example if you have 5 rows in source and 2 rows are duplicate then 4 rows come as output.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>40. Can you sort data on more than one port in sorter transformation?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Yes we can sort data more than one port, but the default port order for sorting is top to bottom. You can select one port ascending and another port descending also. You can move the ports up and down also if you are expecting different sort order.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>41. How do you eliminate duplicate rows using informatica?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">There are two ways to eliminate duplicate rows which are coming from the source. If your source is relational then you can use either first or second option below. Performance wise first option is the best one. If your source is files then you need to go for second option only.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">i) Using Source Qualifier, under properties tab select distinct option</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">ii) Using Sorter, under properties tab select distinct option</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>42. What are different types of caches exist for sorter transformation?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">In general transformations that contains caches internally contains two types data cache and index cache. Sorter transformation has only one cache i.e data cache. This data cache contains output ports from the sorter transformation.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>43. What are different types of joins exist in Joiner transformation?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">There are four different types of joins exist in joiner transformation. In order to use joiner transformation you should have at least two sources. The sources may be tables or files or combination of both.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">1. Normal Join</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">2. Master Outer Join</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">3. Detail Outer Join</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">4. Full Outer Join</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>44. What is master and what is detail in joiner transformation?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We can join only two sources at a time. One we need to consider it as master and the other need to consider it as detail. For performance point of view we take less no.of rows as master and huge no.of rows as detail. Even if you take in reverse direction the output is same. Internally it builds cache for master source.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>43. How many joiner transformations required to join 3 tables?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Two joiner transformations required to join 3 tables. You can join only two tables at a time. First take two tables and then connect to joiner. The third table and first joiner output need to connect to second joiner.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>44. How many joiner transformations required to join n tables?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">(n-1) joiner transformations required to join n tables in informatica power center tool.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>45. What is normal join in joiner transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Normal join means, matching rows come as output from both the sources. You should have at least one common column to join sources.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>46. What is master outer join in joiner transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Matching rows from both the sources and non-matching rows from detail source or normal join + non-matching rows from details source.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>47. What is detail outer join in joiner transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Matching rows from both the sources and non-matching rows from master source or normal join + non-matching rows from master source.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>48. What is full outer join in joiner transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Matching rows come as output from both the sources and non-matching rows from master and detail sources or normal join + non-matching rows from both master and detail sources.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>49. What are different types of caches for joiner transformation?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">There are two different types of caches in joiner transformation</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">1. Data Cache: The file extension is .data</span><br />
<span style="font-family: "verdana" , sans-serif;">2. Index Cache: The file extension is .idx</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>50. What data cache and index cache contains in joiner?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Index Cache contains join condition columns. The join conditions might be on single column or multiple columns.</span><span style="font-family: "verdana" , sans-serif;">Data Cache contains output ports from joiner transformation.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b style="font-family: Verdana, sans-serif; text-align: left;">Informatica Interview Questions PART-II</b><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b style="font-family: Verdana, sans-serif;">51. Can you assign more than one port as rank port in rank transformation?</b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">No, we can assign only one port as rank port in the rank transformation. Double click on rank transformation, select ports tab, under this you can select rank port. If you try to select more than one port, the last port you selected is only checked remaining all unchecked.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>52. How many maximum number of ranks you can give in rank transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The maximum number of ranks allowed in rank transformation is 2147483647. If you try to give more than this number, then it will throw an error.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>53. What is the execution sequence of port orders in a transformation?</b></span></div>
<div style="text-align: justify;">
<br />
<span style="font-family: "verdana" , sans-serif;">Below is the order of execution of ports from top to bottom.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Input/output ports</span><br />
<span style="font-family: "verdana" , sans-serif;">Input Ports</span><br />
<span style="font-family: "verdana" , sans-serif;">Variable Ports</span><br />
<span style="font-family: "verdana" , sans-serif;">Output Ports</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>54. What are different types of constants available in update strategy transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Update strategy transformation allows us to provide either character constants or numeric constants. The default value of update strategy expression is 0. Zero means flagging rows for insert, 1 means flagging rows for update, 2 means flagging rows for delete and 3 means flagging rows for reject.</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">Character Constant</span> <span style="font-family: "verdana" , sans-serif;">OR</span> <span style="font-family: "verdana" , sans-serif;">Numeric Constant</span><br />
<span style="font-family: "verdana" , sans-serif;"> DD_INSERT OR 0</span><br />
<span style="font-family: "verdana" , sans-serif;"> DD_UPDATE OR 1</span><br />
<span style="font-family: "verdana" , sans-serif;"> DD_DELETE OR 2</span><br />
<span style="font-family: "verdana" , sans-serif;"> DD_REJECT OR 3</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>55. Can you update target table data without using update strategy transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">Yes we can update target table data without using update strategy transformation in two ways.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">1. Use update override option, available at target side. Double Click on target instance.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">2. In the session level you can select update as update option and you need to set treat source as update. For this key column should be defined in the target.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>56. What is SCD?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">SCD means slowly changing dimensions, whenever there is a change in the source, what we need to do in our DWH tables. All dimension tables use SCD in data warehousing projects.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b><span style="font-family: "verdana" , sans-serif;">57. What are different types of SCDs?</span></b><br />
<b><span style="font-family: "verdana" , sans-serif;"><br /></span></b>
<span style="font-family: "verdana" , sans-serif;">There are three different types of SCDs.</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">SCD-I: Only maintains current information, If a new record is coming from the source we will insert otherwise we will update.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">SCD-II: Maintains complete history. If a new record is coming from the source or a source row with changes exist then we will insert the record. Old record just we will update flag or version or record_end_dt columns.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">SCD-III: Only Maintains partial history (current and previous only). We maintain two columns for this. Curr_Sal and Previous_Sal. For a new employee we assign value to Curr_Sal column and Previous_Sal column to null.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>58. What is the difference between connected lookup and unconnected lookup?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a. Connected lookup participates in a mapping flow, unconnected lookup doesn't participate in the mapping flow</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">b. Connected lookup returns multiple ports, unconnected lookup can return only one return port</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">c. Connected lookup supports user defined default values, unconnected lookup doesn't support user defined default values</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">d. Connected lookup supports dynamic cache, unconnected lookup doesn't support dynamic cache</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>59. When we go for connected lookup and when we go for unconnected lookup?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">If you want return multiple ports, you can choose connected lookup. If you want to return only one port you can choose either connected lookup or unconnected lookup. If you want to call the same lookup multiple times with different inputs for a single row, then we choose unconnected lookup. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>60. What are different types of caches in lookup?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">There are different types of caches available in look up transformation. By default it will take Static Cache. </span></div>
<div style="text-align: justify;">
<br />
<span style="font-family: "verdana" , sans-serif;">Static Cache : The cache values won't change during session run</span><br />
<span style="font-family: "verdana" , sans-serif;">Dynamic Cache</span><br />
<span style="font-family: "verdana" , sans-serif;">Persistent Cache</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>61. What is dynamic cache?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">A dynamic cache is a cache where you can modify the data in your cache while loading data in to your target table. Generally we go for dynamic cache to filer out one record randomly from the source, if the source has duplicates and target has key columns. To over come the failure on target side, we can use dynamic cache and we load only one record into the target.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>62. What is persistent cache?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Persistent cache is a fixed cache, once you build, you can use same cache in multiple mappings. Generally persistent cache we use, if the same lookup data using in multiple mappings, instead of building same cache multiple times we build only one time and reuse. For first lookup we assign a name, this name we use for all other lookup caches.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>63. What is newlookuprow port?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The newlookuprow port comes into picture when we use dynamic cache. This port automatically adds when you select dynamic cache option in lookup transformation. It returns following values.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"> newlookuprowport=0 ==>No changes to Cache</span><br />
<span style="font-family: "verdana" , sans-serif;"> newlookuprowport=1 ==>Data inserted in the Cache</span><br />
<span style="font-family: "verdana" , sans-serif;"> newlookuprowport=2 ==>Data updated in the Cache</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>64. What is associated port?</b> </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The associated port comes automatically into picture when we select dynamic cache in lookup transformation. It represents with what value need to update the data in the cache.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>65. What is the use of stored procedure transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">To call a pl/sql procedure from informatica, we use stored procedure transformation. There are two types of stored procedure transformations connected and unconnected.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>66. How to convert columns to rows?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Using Normalizer transformation, you can convert columns to rows. After you add the ports into normalizer tab, then you need select occurs clause. If you want to convert 4 columns to 4 rows then you need to select occurs clause with value 4.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>67. When normalizer acts as source qualifier transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">When you drag cobol source into the mapping designer tool from navigation bar, normalizer comes as source qualifier automatically.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>68. What is the difference between GC_ID and GK_ID in normalizer when you define ID with occurs clause?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">GC_ID and GK_ID comes automatically for ports, when you select occurs clause for that port. GC_ID means Generated Character ID, it gives repetition of values to rows based on occurs clause. If we give occurs 3, then it repeats the sequence 1,2,3 again 1,2,3 etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">GK_ID means Generated Key Value, it gives continuous sequence 1,2,3,4,5,6 etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>69. What is the priority in source qualifier if we give filter condition (dno=10) and also sql override (dno=20)?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">If you double click on source qualifier, you can see both the properties filter condition and sql override. The highest priority is sql override, it takes the condition dno=20. If you don't provide sql override then it will take value from the filter condition.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>70. Can we connect more than one source to a single source qualifier?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">yes, we can connect more than one source to a single source qualifier. When you drag multiple sources, for each source you can see one source qualifier, you need manually delete all source qualifier except one and then all other sources ports you can connect to one source qualifier.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>71. What is the difference you observed between source and source qualifier?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Source contains source DB data types, where as source qualifier contains informatica data types. Informatica cannot understand source data types so automatically converts to informatica data types. For example if you drag oracle source, number is converted to integer, varchar is converted to string etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>72. What are different types of stored procedures?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br />There are two different types of stored procedures.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a) Connected Stored Procedure: It is linked to other transformations in a mapping</span><br />
<span style="font-family: "verdana" , sans-serif;">b) Unconnected Stored Procedure: It is not linked to any other transformations in a mapping. We can call this using expression transformation.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>73. What is the difference between top down and bottom up approach?</b></span><br />
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">see the below video</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><a href="https://youtu.be/3-kZaJOtcfs">https://youtu.be/3-kZaJOtcfs</a></u></span><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<b style="font-family: Verdana, sans-serif;">74. What is target load plan?</b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">If a mapping contains multiple flows, which flow target table should load first decides target load plan. Generally we use this, if one flow target becomes source for another flow. This option is available under mappings menu.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>75. How do you create a reusable transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can create reusable transformations using transformation developer tool. Once you create reusable transformation you can see in the navigation bar under transformations folder.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>76. What is the use of reusable transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If there is a change in the logic, you need not touch all the mapping where ever you used reusable transformation, just change at only one place i.e at transformation developer tool, automatically that change will reflect to all of the mappings.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>77. What is a mapplet?</b> </span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">A mapplet is a reusable logic, which is built based on multiple transformations. You can create mapplets under mapplet designer tool. The same mapplet you can us in n number of mappings, in future if there is any change in logic you need not touch all the mappings, just you need to change at only one place i.e in the mapplet.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>78. What are different types of mapplets?</b> </span><br />
<br /></div>
<span style="font-family: "verdana" , sans-serif;">There are two different types of mapplets. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">a) Active Mapplets</span><br />
<span style="font-family: "verdana" , sans-serif;">b) Passive Mapplets</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>79. What is active mapplet?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If a mapplet contains atleast one active transformation then it is called active mapplet. Every mapplet contains one mapplet input and mapplet out transformation.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>80. What is passive mapplet?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">If a mapplet contains all passive transformations then it is called passive mapplet. Passive mapplets give more performance than active mapplets.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>81. What are different types of restrictions while creating mapplets?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">a) You can't use XML sources</span><br />
<span style="font-family: "verdana" , sans-serif;">b) You can't use targets</span><br />
<span style="font-family: "verdana" , sans-serif;">c) If you want to use sequence generator that should be reusable</span><br />
<span style="font-family: "verdana" , sans-serif;">d) If you want to use stored procedure that should be normal</span><br />
<span style="font-family: "verdana" , sans-serif;">e) You can't use normalizer transformation</span><br />
<span style="font-family: "verdana" , sans-serif;">f) Nesting of mapplets not allowed</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>82. What are the optimization techniques for joiner transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">a) Take less no.of rows as master and huge number of rows as detail</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">b) Sorted Input, which is available under properties tab of joiner transformation</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>83. When you select sorted input option in joiner what ports you need to sort?</b></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><br />
<span style="font-family: "verdana" , sans-serif;">The join condition columns in both the sources need to be sorted. You can sort those ports using sorter transformations before joiner or in the source qualifier itself. We can sort the port either in ascending or descending order.</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;"><b>84. What happens if you don't sort the data and you selected sorted input option?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If you select the sorted input option and don't sort the sources data, then the session will fail.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>85. What are the optimization techniques for lookup?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">a) Use lookup override</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">b) Join condition order =, >, >=, <, <=, !=</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">c) Persistent Cache</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>86. What are different types of power center client tools?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">a) Power Center Designer</span><br />
<span style="font-family: "verdana" , sans-serif;">b) Power Center Workflow Manager</span><br />
<span style="font-family: "verdana" , sans-serif;">c) Power Center Workflow Monitor</span><br />
<span style="font-family: "verdana" , sans-serif;">d) Power Center Repository Manager</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>87. How to copy the code from one repository to another?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Export the code as xml from one repository and import that xml into another repository or you can create a deployment group in one repository and copy that deployment group to another repository.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>88. What is impacted mapping?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If any of the components in the mapping changed, example sources or targets or reusable transformations or mapplets then mapping becomes impacted. It gives in yellow color triangle symbol. We have to validate the mapping to disappear impacted symbol.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>89. When mapping becomes invalid?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Invalid mapping shows is red color ball symbol. In order to execute the mapping it should be valid state. For example if you use joiner transformation in a mapping and don't give any join condition then mapping becomes invalid. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>90. What is mapping parameter?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">A mapping parameter represents constant value, generally we use mapping parameters if the values are changing frequently. Mapping parameter starts with $$ symbol.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>91. Where the parameter values stored?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The mapping parameter values stored in a parameter file. A parameter file is a text file that contains parameter header followed by parameters and values. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>92. What are different types of parameter headers?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">[GLOBAL]</span><br />
<span style="font-family: "verdana" , sans-serif;">[session_name]</span><br />
<span style="font-family: "verdana" , sans-serif;">[workflow name]</span><br />
<span style="font-family: "verdana" , sans-serif;">[folder_name.wf:workflowname.st:session_name] etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>93. What happens if a parameter not defined in a parameter file?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The session won't fail, it uses default value. In the session log we can verify whether the parameter has taken value or not.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>94. Where to declare a parameter?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">In power center designer tool, menu bar select mappings and then parameters and variables. You can declare multiple parameters with in a mapping. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>95. What is a mapping variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">A mapping variable is a variable, the value is stored in informatica repository at the end of successful session run. Both parameters and variables starts with $$ symbol.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>96. What is the difference between mapping parameter and variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Parameter values stored in a file, where as variable values stored in a repository. Parameter values can't change during session run, variable values can change during session run.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>97. How do you change the value of variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The value of a variable we can change using below functions</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">SetVariable()</span><br />
<span style="font-family: "verdana" , sans-serif;">SetMaxVariable()</span><br />
<span style="font-family: "verdana" , sans-serif;">SetMinVariable() etc</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>98. How do you know the current value of the variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">In workflow manager tool, select workflow designer tool, select the session right click and select view persistent values option.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>99. Can you reset the value of a variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Yes we can reset the value of a variable. </span><span style="font-family: "verdana" , sans-serif;">In workflow manager tool, select workflow designer tool, select the session right click and select view persistent values option. Here you can see reset option.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>100. How do you override the present value of variable?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">By using parameter file, we can override the current value of a variable. We need to give parameter file path in the session level or workflow level.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b style="font-family: Verdana, sans-serif; text-align: left;">Informatica Interview Questions PART-III</b><br />
<b style="font-family: Verdana, sans-serif; text-align: left;"><br /></b>
<b style="font-family: Verdana, sans-serif; text-align: left;">101. What is a tracing level?</b><br />
<b style="font-family: Verdana, sans-serif; text-align: left;"><br /></b>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Tracing level represents the amount of information written into the session log. You can set tracing level option in the transformation level or session level. If you want to set at transformation level, double click on the transformation and select properties tab. Under properties tab you can select tracing level. If you want to set at session level, double click on the session and select config object and then select override tracing option.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>102. What are different types of tracing levels?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Terse: Lowest amount of information compared to all other tracing levels, logs just status information and errors.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Normal: Logs initialization Information, Status information and rows skipped due to transformation errors.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Verbose Initialization: Normal tracing information and logs names of data and index file names.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Verbose Data: All information you can get here, status initialization, errors, column by column and row by row values</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">We use verbose data, if we want debug our code. Verbose data gives more information compared to all other tracing levels.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>103. What is line sequential buffer length option?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif; text-align: left;">This option is available at session level under config object. The default value for this option is 1024 bytes. We need to alter the value for this option when the length of the record in the flat file exceeds 1024 characters. If the length of the row in a flat file is 2000 characters then we need to set line sequential buffer length as 2000.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>104. What are different types of flat files?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b><br /></b></span>
<br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">There are two different types of flat files. A flat file is a notepad file or text file that contains organised data.</span></div>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif; text-align: left;">a) Fixed Width: In this file each and every field is defined with fixed length. If the value of the filed exceeds the field length, the exceeded value moved to next field value.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">b) Delimited: In this file each and every field is separated by some symbol. In real time most of the times we see comma and pipe delimited flat files.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>105. Can informatica handle multiple delimited flat files?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b><br /></b></span>
<br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Informatica can handle multiple delimited flat files. We can specify list of delimiters one after another. </span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Eg:- Row Contains Multiple Delimiters</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">100|ravi,2000|New York </span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Here we need to specify two delimiters to handle this data , and | symbols.</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>106. How to load the flat file name into a table?</b></span></div>
<b style="font-family: Verdana, sans-serif; text-align: left;"><br /></b><span style="font-family: "verdana" , sans-serif; text-align: left;">When you drag flat file source into a mapping, along with source, source qualifier comes automatically. In the source qualifier properties tab you need to select "Currently Processed File Name" option. Then you can connect this port to target table.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>107. How to skip header from a flat file?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">You need to set the property number of initial rows to skip to 1. This option you can set in the session level or under source analyzer tool.</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>108. How to skip top 3 rows from a flat file?</b></span></div>
<b style="font-family: Verdana, sans-serif; text-align: left;"><br /></b>
<span style="font-family: "verdana" , sans-serif; text-align: left;">You need to set the property number of initial rows to skip to 3. </span><span style="font-family: "verdana" , sans-serif; text-align: left;">This option you can set in the session level or under source analyzer tool.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>109. How to skip footer from a flat file?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;">Read the footer value into the first port and use filter transformation and then you can skip the footer.</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>110. What are the characteristics of data warehouse?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<br />
<div>
<span style="font-family: "verdana" , sans-serif;">see the below video</span></div>
<div>
<br /></div>
<div>
<span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><a href="https://youtu.be/3-kZaJOtcfs">https://youtu.be/3-kZaJOtcfs</a></u></span><br />
<span style="color: #0000ee; font-family: "verdana" , sans-serif;"><u><br /></u></span></div>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>111. How to you load multiple flat file data at the same time?</b></span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span><span style="font-family: "verdana" , sans-serif; text-align: left;">Use file indirect or file list method. In the session level you need to set source file type as Indirect. The source file name you need to give the file that contains list of all other files</span><br />
<span style="font-family: "verdana" , sans-serif; text-align: left;"><br /></span>
<span style="font-family: "verdana" , sans-serif; text-align: left;"><b>112. What are the prerequisites to use file list or file indirect method?</b></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">a) All files should have same no.of columns</span><br />
<span style="font-family: "verdana" , sans-serif;">b) All files have same delimiter</span><br />
<span style="font-family: "verdana" , sans-serif;">c) All files may or may not have header</span><br />
<span style="font-family: "verdana" , sans-serif;">d) All files should have same data types for the columns</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>113. What is the most frequently used row delimiter in a flat file?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">/r/n ==>Carriage Return followed by new line character.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>114. What is the disadvantage of fixed width flat file?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If the value of the field exceeds the length of the field, then that value read into the next field.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>115. How many ways you can get the source structure of a flat file?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If file is already available, we can directly select the option import from file under source analyzer tool. If file not exists then we need to select the create option under source analyzer.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b><span style="font-family: "verdana" , sans-serif;">116. </span><span style="font-family: "verdana" , sans-serif;">How many ways you can get the target structure of a flat file?</span></b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">If file is already available, we can directly select the option import from file under target designer tool. If file not exists then we need to select the create option under target </span><span style="font-family: "verdana" , sans-serif;">designer.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>117. How can you eliminate duplicate records from a flat file?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">You need to user sorter transformation. Under properties tab need to select distinct option.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>118. What is the default value of Stop On Errors?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The default value of Stop On Errors is zero. If any error comes it will by default write into the session log and session will succeed.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>119. How to fail a session when any error comes?</b></span><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">You need to set Stop On Errors to 1. This property is available under session config object.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>120. How to fail a session after 5 errors?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">You need to set Stop On Errors to 5. </span><span style="font-family: "verdana" , sans-serif;">This property is available under session config object.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>121. What are different tools available under workflow manager?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Task Developer</span><br />
<span style="font-family: "verdana" , sans-serif;">Worklet Designer</span><br />
<span style="font-family: "verdana" , sans-serif;">Worflow Designer</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>122. How can you create a reusable session?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If we create a session under task developer tool i.e automatically reusable and it is available in the navigation bar under sessions folder.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>123. How can you create a non-reusable session?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If we create a session under workflow designer tool i.e automatically non-reusable. You cannot use this session in another workflow and is restricted to that workflow only.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>124. What is the difference between reusable and non-reusable tasks?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">If you create any task under task developer i.e reusable, you can use that task in n number of workflows. If you create any task under workflow manager i.e non-reusable i.e restricted to that workflow only</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>125. What are different reusable tasks?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Session</span><br />
<span style="font-family: "verdana" , sans-serif;">Email</span><br />
<span style="font-family: "verdana" , sans-serif;">Command</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>126. What are different non-reusable tasks?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Event Wait</span><br />
<span style="font-family: "verdana" , sans-serif;">Event Raise</span><br />
<span style="font-family: "verdana" , sans-serif;">Timer</span><br />
<span style="font-family: "verdana" , sans-serif;">Decision</span><br />
<span style="font-family: "verdana" , sans-serif;">Assignment</span><br />
<span style="font-family: "verdana" , sans-serif;">Control</span><br />
<br />
<b style="font-family: Verdana, sans-serif;">127. What is the use of e-mail task?</b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">Generally E-mail task is used at the end of the workflow, to send a mail to business about today's data loads status</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>128. What is the use of command task?</b></span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">Command task is used to execute any unix commands or to call a shell script</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>129. What is the use of event wait task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Event wait task is used to wait for a file and check that file exists at particular path frequently at regular intervals. Generally this is used as the first task in the workflow, to check the source system is ready or not</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>130. What is the use of timer task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The timer task is used to wait the process particular time. At that time the timer task will execute. For example you have two sessions, after one session succeeds you need to wait 1 min and then you need to start another session. In this scenario we can use timer for 1 min</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>131. What is the use of decision task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The decision task is used to avoid multiple link conditions. For example after 10 sessions succeeds then you want to run another task then we can use single decision task after 10 sessions </span><br />
<br />
<b style="font-family: Verdana, sans-serif;">132. What is the use of assignment task?</b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">Assignment task is used to assign values to workflow variables</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>133. What is the use of control task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Control task is used to fail the parent i.e workflow or worklet</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>134. When session fails will workflow also fail?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">No by default when session fails workflow succeeds</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>135. When session fails how can you fail workflow also?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">You need to check the property, Fail Parent If this Task Fails. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>136. How to disable the task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Double click on that task and check the property Disable the task</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>137. Can you convert non-reusable task to reusable task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Yes we can convert from non-reusable task to reusable task, double click on the task and top corner you need to select check box reusable.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>138. Can you convert reusable task to non-reusable task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can't convert reusable task to non-reusable task. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>139. How many ways you can create workflows?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can create workflows in two ways.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Parallel: From start icon in the workflow, we can connect multiple tasks, all these will run at the same time. </span><br />
<span style="font-family: "verdana" , sans-serif;">Sequential: From start icon in the workflow, we can connect one task after another task sequentially.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>140. Where do you set parameter file?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">You can give parameter file and path name either in the session level or workflow level. Some times we can directly use parameter file name along with pmcmd command.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>141. What is the default commit interval?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The default commit interval is 10000. Once 10000 rows reached to target it will apply commit operation. We have the flexibility to increase or decrease commit interval value.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>142. Will session log override when you run the session second time?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Yes by default the session log will override, when ever we run a session, unless you specify properties number of runs or by time stamp.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>143. How do you overcome session log override?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The are two ways you can set</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">1. Number Of Session Runs: Need to specify number of session logs maintain.</span><br />
<span style="font-family: "verdana" , sans-serif;">2. By Time stamp: It will create new session log every time you run the session.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>144. What might be the reasons, your session failed with table or view doesn't exist ?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">There might be several reasons for failure.</span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">1. Table Not exist in the database</span><br />
<span style="font-family: "verdana" , sans-serif;">2. Schema name not specified</span><br />
<span style="font-family: "verdana" , sans-serif;">3. Grants are not available for that relational connection user</span><br />
<span style="font-family: "verdana" , sans-serif;">4. Relational connection is wrong</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>145. What happens to third session if second session failed in the workflow, workflow contains 3 sessions?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">By default third session will execute even if the second session fails and also it will show workflow as succeeded, unless if you specify fail parent if this task fails option.</span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;"><b>146. How to make it happen in a workflow only one task succeeds then only need to run another task?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">We need to connect all tasks with in a workflow using links. By using link task, task we can set status=succeeded. Just double click on the link then it opens a dialogue box. If you set this if first task succeeds in a workflow then only second task will start.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>147. What is a domain?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Domain is a collection of nodes and services. You can configure domain details at the time of informatica server installation. You can use power center informatica administration console to get more details about your environment.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>148. What is a node?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">A node is a logical representation of a machine. In real time we can see multiple nodes in a single environment. One node act as master gateway node and all other nodes work as worker nodes. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<b style="font-family: Verdana, sans-serif;">149. What are main different services in power center?</b><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">The following are different services in power center tool</span><br />
<b style="font-family: Verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">Repository Service: It is responsible for retrieving or inserting data into the repository database.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Integration Service: It is responsible for running workflows and talks with repository service.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>150. When you log in which component checks user validation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">When you connect to repository using userid and passowrd, service manager is responsible for authorization and authentication. Service manager is one of the component in power center tool.</span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<b style="font-family: Verdana, sans-serif; text-align: left;">Informatica Interview Questions PART-IV</b><br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>151. What is the use of sequence generator transformation?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Sequence generator transformation is a passive and it is connected. Sequence generator transformation is used to generate sequence of numbers (1,2,3,4....etc) or sequence of intervals (10,20,30,40...etc) or cyclic values (1,2,3,1,2,3,1,2,3,1,....etc). In real time sequence generator transformation is used to generate surrogate key values in SCD type-ii mappings.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>152. How do you know current value of sequence generator?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
</div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We can know the current value of the sequence generator transformation without running the session. From the navigation bar, disconnect to the folder and connect again, open the mapping and then double click on the sequence generator transformation, select properties tab, you can see the current value.</span></div>
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>153. What is the use of reset option in sequence generator?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The reset option is available under properties tab of the sequence generator transformation. When you select reset option, every time when you run the session the sequence generator starts with same value. In real time we set this option if the target table is truncate and load.</span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>154. What happens if you connect same sequence generator to two targets?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">When you connect same sequence generator transformation to two different targets, it gives different values. For example if it assigns values 1,2,3,4 to first target then for second target it assigns values 5,6,7,8. </span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>155. What happens if you connect only currval port from sequence generator?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you connect only currval port from sequence generator transformation, then it assigns same currval to all the rows. Currval port automatically comes into sequence generator when you create, you can't delete this port from the transformation.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>156. Will union transformation eliminate duplicates?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The union transformation won't eliminate duplicates, it is equal to union all operation in oracle. If you want to delete duplicate rows then you need to place a sorter transformation after union and you need to enable distinct option which is available under properties tab of sorter transformation.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>157. What are restrictions in order to use union transformation?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">You can connect n number of sources to union transformation. All the sources should have same number of columns and data types also. Suppose if one of the source has less number of columns, we can create a dummy port and we can use this while connecting to union transformation.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>158. What is target pre sql?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The target pre sql option is available at the session level. Doublce click on the session, select mappings tab, select targets left side, right side you can see this option. If you want to execute any sql statement before loading into your target you can use this. In real time we use this option to drop indexes before loading data into the target table.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>159. What is target post sql?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif; text-align: justify;">The target post sql option is available at the session level. Doublce click on the session, select mappings tab, select targets left side, right side you can see this option. If you want to execute any sql statement after loading into your target you can use this. In real time we use this option to re create indexes after loading data into the target table.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>160. How can you send a mail when a session fails?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We have predefined option at the session level, to send a mail when the session fails. Double click on the session, select components tab, there is a property "On Failure E-mail". You can select either reusable or non-reusable e-mail task.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>161. How do you fail a session explicitly?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We can fail a session explicitly by calling abort() function in the mapping. We can call abort() function from the expression transformation. For example if you want to fail a session when the date is invalid, then in the expression you need to create output port and need to set value like this. </span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">IIF(IS_DATE(EXP_DATE,'YYYYMMDD')!=1,ABORT("Invalid Date"))</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>162. What is a short cut?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">A short cut is a repository object from a share folder. You can create shortcuts for sources, targets and mappings also. In real time we use short cuts if same sources or targets or mappings used by multiple departments or line of businesses.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>163. How can you compare folders from different repositories ?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Using repository manager, we can compare folders from different repositories. Connect to both the repositories using login credentials. After this you can select same folder from each repository and compare. It gives result similarities and differences from both the folders.</span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>164. Lookup transformation is active/passive?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Up to Informatica 8 version, lookup is passive. From version 9 onward it is active. By default it is passive in 9 version also, if you want convert to active, at the time of creation, select the check box.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>165. What is the difference between stop and abort?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">When you click on stop, immediately it stops reading, continue processing and writing data to the target for commit, process waits till commit applied on the target. Abort also stops reading, continue processing and writing data to the target for commit. If commit doesn't happen in 60 seconds, it immediately kills writer thread.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: "verdana" , sans-serif;">166. W</span><span style="text-align: left;"><span style="font-family: "verdana" , sans-serif;">hat is the </span></span></b><b style="font-family: Verdana, sans-serif; text-align: left;">difference </b><b><span style="text-align: left;"><span style="font-family: "verdana" , sans-serif;">between reusable transformation and mapplet?</span></span></b></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">You can't link multiple transformations under transformation developer as reusable. Mapplets allow you to link multiple transformations in order to build a reusable business logic. You need to use transformation developer tool to create reusable transformation. You need to use mapplet designer tool to create a mapplet.</span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">167. Can you tell</span><span style="text-align: left;"><span style="font-family: "verdana" , sans-serif;"> 4 output files that informatica generates during session running?</span></span></b></div>
<div style="text-align: justify;">
<b><span style="text-align: left;"><span style="font-family: "verdana" , sans-serif;"><br /></span></span></b></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Session Log</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Workflow Log</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Error Log</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;">Bad File</span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>168. Can we return multiple ports from unconnected lookup?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Yes we can return multiple ports from unconnected lookup indirectly by concatenating multiple ports as single and then you can select that port as return port. Once we get this port value, using expression we can break value into multiple ports.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>169. What is the use of bulk load option?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">This option is available at session level. Double click on the session, select mappings tab, select targets and right side you can see the option "Target Load Type". By default it is bulk, you can also set normal. When you select bulk load option, the target writing performance is high. It internally calls bulk utility and by passes redo log file.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>170. What is the disadvantage of bulk load?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">The disadvantage of bulk load utility is you cannot recover the data, why because it writes data into the data file, it won't write data into the redo log file. If you want to recover data the data should be available in the redo log file also.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>171. Can you use bulk load if indexes exist on target table?</b></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Bulk load won't support if you have defined indexes on your target table. In order to use bulk load, drop indexes before load and create indexes after loading data into the target table.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<b><span style="font-family: "verdana" , sans-serif;">172. </span><span style="font-family: "verdana" , sans-serif;">What is code page?</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: "verdana" , sans-serif;"><br /></span></b></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">A code page represents the character set. Character set represents alphabets, digits and special characters.There are different types of code pages ASCII, EBCIDIC, UTF etc. Source and target data falls under some code pages. </span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>173. When code page comes into picture?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">We give code page while creating relational connections. If you want to write data into the database other than alphabets, digits and special characters for example non-English characters then we need to change accordingly. But your target data base also should support that code page.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>174. What is a surrogate key?</b></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">A surrogate key is an artificial key, which is not coming from the source. We are going to generate surrogate key values using sequence generator transformation.</span></div>
</div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><b>175. what is push down optimization?</b></span></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Push down optimization means pushing business logic handing into the database side instead of handling in the informatica server level. When we use this option, internally it creates sql for transformations in the mapping and it will fire on the database.</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>176. what are different types of push down optimization?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">There are 3 types of push down optimization</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><span style="font-family: "verdana" , sans-serif;">a) Source Side </span><span style="font-family: "verdana" , sans-serif;">push down optimization: From source to upstream transformations, creates sql and fire it on the database.</span></span></div>
<br />
<div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">b) Target Side </span><span style="font-family: "verdana" , sans-serif;">push down optimization: From target to downstream transformations, creates sql and fire it on the database.</span></div>
</div>
<div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">c) Full </span><span style="font-family: "verdana" , sans-serif;">push down optimization: From sources and targets, creates sql and fire it on the database.</span></div>
</div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b>177. What is pmcmd?</b></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">PMCMD is a command line utility, used to run the workflow from command line. Generally we use this command in unix shell scripts.There are different options available with this command, you can set parameter file also in the command itself.</span></div>
</div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b>178. What is a worklet?</b></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">A worklet is a group of reusable tasks. You can link multiple tasks with in a worklet. You can link the tasks parallel or sequential. The tasks might be session, email, command, decision, timer, control etc</span></div>
</div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b>179. Where do you create a worklet?</b></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">You can create worklet under worklet designer tool. The worklet designer tool is available under power center workflow manager tool. When you crate a worklet you can see start icon similar to workflow icon.</span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b>180. When we go for worklets?</b></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">If you want to execute some number of tasks in multiple workflows in order to fulfill particular business logic.In future if you wan to add one more task, you need not touch all workflows, just add at only one place under worklet designer, that change automatically will reflect in all workflows. It saves a lot of time for build.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>181. Can we nest worklets?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Yes you can include one worklet in another worklet. Including one worklet in another worklet known as nesting worklets. In worklet designer tool select insert option and then select another worklet you want to include.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>182. Can you run a worklet with out a workflow?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can't run a worklet without workflow even though start symbol exists for worklet also. If you want to execute a worklet you need to place in workflow only similar to the tasks in the workflow.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>183. Can you run a workflow with out a session?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Yes we can run a workflow with out session task. We can run any other tasks email or command or timer or control or event wait etc with in the workflow.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>184. What is throughput?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Throughput represents number of rows read from source per second and the number of rows writing in to the target. It shows number of bytes along with number of rows.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>185. What is the use workflow monitor?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Using workflow monitor we can view the load statistics, how many rows read from source, how many rows written and failure and success statuses. Using this we can see history runs also.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>186. What are different views under workflow monitor?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">There are two different views under workflow monitor</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Task View: This view displays workflow run details in chronological format.</span><br />
<span style="font-family: "verdana" , sans-serif;">GanttChart View: This view displays workflow run details in report format.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>187. What is the difference between applied rows and affected rows?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Applied rows on the target side means number of rows reached to the target and affected rows means number of rows actually updated or deleted or inserted in the target. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>188. How many ways you can create ports?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span><span style="font-family: "verdana" , sans-serif;">There are different ways you can create ports. One way is double click and go to ports tab, select the icon add a new port to the transformation another option is you can directly drag from another transformation.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>189. What is propagate attributes option?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Using this option you can propagate attribute names, data types and size from one transformation to other entire flow. Generally we use this option in enhancements of the project. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>190. How do you create a relational connection?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">Under workflow manager tool, in the menu bar select connections, select database, give connection name, userid and password. Generally we can create relational connections only for databases.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;"><b>191. What is the default condition in filter transformation?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">The default condition for filter transformation is TRUE. Just if we connect filter and don't give any condition then, what ever the rows entered into filter are moving to next level transformation or target. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>192. What is the difference between replacechr() and replacestr()?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">Replacechr() function is a character by character replacement. Replacestr() is a string by string replacement.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Eg:- replacechr(0,'abcd','ac','fx') </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"> output: fbxd</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Eg:- replacestr(0,'abcd','ac','fx')</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"> output: abcd </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">In the original string it looks for "ac", it is not available.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>193. How to compare two dates in informatica?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can compare two dates in informatica using predefined function date_comapre(). This function takes two arguments. If date1 is less than date2 then it retruns -1, if date1 is greater than date2 then it returns 1 if date1 and date2 are equal then it returns 0.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>194. How to remove spaces at the beginning and end of a string?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can remove spaces at the beginning and end of a string using LTRIM and RTRIM functions. Both these functions you can apply at the same time on a string. ltrim(rtrim(String)).</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>195. How to check date is valid or not in informatica?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can check date is valid or not using predefined function IS_DATE(). This function takes two arguments, first argument is date and the second argument is format of the date. If it is valid date then it returns 1 else it returns 0.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Eg: IS_DATE(PORT,FORMAT) IS_DATE('2016/12/12','YYYY/MM/DD');</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>196. What is the difference between SYSDATE and SESSIONSTARTTIME?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">SYSDATE gives current time of that node at that time, it will change while loading huge data you can observe. SESSIONSTARTTIME is the time represents constant value during entire session run, that contains time at the session started.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>197. How to remove new line character in a column value?</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can remove new line character in a character column using replacestr() function. In real time we face this kind of issue, if the column value contains huge amount of data.</span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">REPLACESTR(1,STRING_PORT,CHR(10),CHR(13),'')</span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<br />
<div style="text-align: left;">
<b style="font-family: Verdana, sans-serif; text-align: justify;">198. What are different types of data loads in DWH project?</b><br />
<b style="font-family: Verdana, sans-serif; text-align: justify;"><br /></b>
<span style="font-family: "verdana" , sans-serif; text-align: justify;">There are two different types of data loads in DWH project</span></div>
<div style="text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;"><br /></span></b></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">History Load: First we load entire data into the DWH from the beginning of the business to till date.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Incremental Load Or Delta Load: Incremental data include daily data after history load or some times weekly data.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>199. What is a data map?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">A data map is a file layout. Generally we create data maps when we work with EBCIDIC files. We use power exchange tool to create data maps. A data map contains record and table.</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b>200. How many ways you can implement incremental load?</b></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">We can implement increment loads in DWH projects in different ways</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">1. Using Mapping Parameters</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">2. Using Mapping Variables</span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">3. Using Control table</span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><br />
<br />
<b style="font-family: verdana, sans-serif;">Real time Project Assignment</b><br />
<b style="font-family: verdana, sans-serif;"><br /></b>
<span style="font-family: "verdana" , sans-serif;">If you are already trained on informatica and looking for real time project assignment, contact me.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Project: Quality Datamart</span><br />
<span style="font-family: "verdana" , sans-serif;">Domain: Quality</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Docs:</span><br />
<br />
<ul>
<li><span style="font-family: "verdana" , sans-serif;"> Functional Specification Document</span></li>
<li><span style="font-family: "verdana" , sans-serif;"> ETL Technical Specification Document</span></li>
<li><span style="font-family: "verdana" , sans-serif;"> Data Model</span></li>
</ul>
<br />
<span style="font-family: "verdana" , sans-serif;"><b>Trainer:</b> Venkat</span><br />
<span style="font-family: "verdana" , sans-serif;"><b>Moblile:</b> 91-8008829289</span><br />
<span style="font-family: "verdana" , sans-serif;"> 91-9886895594</span><br />
<span style="font-family: "verdana" , sans-serif;"><b>E-mail:</b> informaticatrainer.expertise@gmail.com</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">For more information, check the below link</span><br />
<span style="font-family: verdana, sans-serif;"><br /></span>
<span style="font-family: verdana, sans-serif;"><a href="https://informaticaonlinetraing.blogspot.com/">https://informaticaonlinetraing.blogspot.com</a></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
</div>
</div>
</div>
</div>
INFORMATICA INTERVIEW QUESTIONShttp://www.blogger.com/profile/12685042418418004339noreply@blogger.com39