Informatica Scenario Based Questions - Part 2

1. Consider the following employees data as source employee_id, salary 10, 1000 20, 2000 30, 3000 40, 5000 Q1. Design a mapping to load the cumulative sum of salaries of employees into target table? The target table data should look like as employee_id, salary, cumulative_sum 10, 1000, 1000 20, 2000, 3000 30, 3000, 6000 40, 5000, 11000 Solution: Connect the source Qualifier to expression transformation. In the expression transformation, create a variable port V_cum_sal and in the expression editor write V_cum_sal+salary. Create an output port O_cum_sal and assign V_cum_sal to it. Q2. Design a mapping to get the...

Informatica Scenario Based Interview Questions with Answers - Part 1

1. How to generate sequence numbers using expression transformation? Solution: In the expression transformation, create a variable port and increment it by 1. Then assign the variable port to an output port. In the expression transformation, the ports are: V_count=V_count+1 O_count=V_count 2. Design a mapping to load the first 3 rows from a flat file into a target? Solution: You have to assign row numbers to each record. Generate the row numbers either using the expression transformation as mentioned above or use sequence generator transformation. Then pass the output to filter transformation and specify the filter...

Convert single row from source to three rows in target

Scenario1: We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:   Col1 Col2 Col3 a b c There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:   Col a b c Without using normaliser transformation. Solution:   Create 3 expression transformations exp_1,exp_2...

Optimal decision tree based multi-class support vector machine

In this paper, decision tree SVMs architecture is constructed to solve multi-class problems. To maintain high generalization ability, the optimal structure of decision tree is determined using statistical measures for obtaining class separability. The proposed optimal decision tree SVM (ODT-SVM) takes advantage of both the efficient computation of the decision tree architecture and the high classification accuracy of SVM. A robust non-parametric test is carried out for statistical comparison of proposed ODT-SVM with other classifiers over multiple data sets'. Performance is evaluated in terms of classification accuracy and...

Email task, Session and Workflow notification : Informatica

One of the advantages of using ETL Tools is that functionality such as monitoring, logging and notification are either built-in or very easy to incorporate into your ETL with minimal coding. This Post explains the Email task, which is part of Notification framework in Informatica. I have added some guidelines at the end on a few standard practices when using email tasks and the reasons behind them. 1. Workflow and session details. 2. Creating the Email Task (Re-usable) 3. Adding Email task to sessions 4. Adding Email Task at the...

Information Technology – A Definition:

We use the term information technology or IT to refer to an entire industry. In actuality, information technology is the use of computers and software to manage information. In some companies, this is referred to as Management Information Services (or MIS) or simply as Information Services (or IS). The information technology department of a large company would be responsible for storing information, protecting information, processing the information, transmitting the information as necessary, and later retrieving information as necessary. History of Information Technology: In relative terms, it wasn't long ago that the Information...