4.38 out of 5
4.38
21 reviews on Udemy

50 Informatica Interview Scenarios – Solved

Informatica Scenarios Practically Solved with explanation.
Instructor:
Saif Shaikh
144 students enrolled
English [Auto-generated]
You will be able to crack interviews, answer the scenario based questions in interviews and approaches to solve given scenarios
Example: Divide the data in two half & load in two separate table

These are 50 Informatica ETL Scenario based solution which will help learners to enhance and be more confident on this technology. Professionals can implement these on their laptops and understand the logic written which will help them to grow technically and also enhance broader vision when a problem statement comes in front of them.

Informatica ETL Tool is widely used in many MNCs and having a sound knowledge in ETL Tool will help them to be on top of their toes in industry.

Informatica ETL Interview Scenarios

1
Scnr_1_Converting_Column_to_Rows
2
Scnr_2_Split_NonKey_Columns
3
Scnr_3_Generating_SeqNo_Using_Exp_Trnfn
4
Scnr_4_Separating_Dup_NonDup_Records
5
Scnr_5_SplittingRecords_Cyclic_Orderof_10
6
Scnr_6_Concatenating_Values
7
Scnr_7_Cumulative_Sum_Salary
8
Scnr_8_Adding_Previous_Row_Salary_Only
9
Scnr_9_Generating_Filename_Dynamically
10
Scnr_10_Removing_Dollar_Sign
11
Scnr_11_Add_$_Sign_to_Sal
12
Scnr_12_Using_Mapping_Parameter_in_ParamFile
13
Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls
14
Scnr_14_Count_No_of_Vowels_Consonants
15
Scnr_15_Removing_Special_Char
16
Scnr_16_Days_Difference_2_Days
17
Scnr_17_Date_Difference_in_Hrs
18
Scnr_18_Adding_Days_to_Date
19
Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year
20
Scnr_20_Extracting_FNAME_MNAME_LNAME
21
Scnr_21_Convert_Number_Value_to_Date
22
Scnr_22_Checking_Hiredate_Column
23
Scnr_23_Separating_H_D_F
24
Scnr_24_Dup_NonDup_in_2_Method
25
Scnr_25_Previous_Row_Salary_Current_Row
26
Scnr_26_Next_Row_Sal_Curr_Row
27
Scnr_27_Sum_of_Sal_Repeat_On_All_Rows
28
Scnr_28_Concatenate_Values_Per_ID_Column
29
Scnr_29_Concatenate_All_Values
30
Scnr_30_Concatenate_Values_ID_Column_Only
31
Scnr_31_Slit_Half_Records_Into_Separate_Table
32
Scnr_32_Except_Last_5_Records
33
Scnr_33_Split_Odd_Even_Records
34
Scnr_34_Use_Mapping_Parameter_In_Paramfile
35
Scnr_35_Generate_Seq_via_SQL_Transf
36
Scnr_36_Generate_FF_Dynamically_Deptno
37
Scnr_37_Load_Mutliple_Files_In_Single_File
38
Scnr_38_First_Last_Record_Same_Table
39
Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf
40
Scnr_40_Replace_Dollar_With_Rupee_Sign
41
Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf
42
Scnr_42_Extracting_Every_5th_Row
43
Scnr_43_First_3_Records
44
Scnr_44_Last_3_Records
45
Scnr_45_Run_3rd_Session_After_3_Runs_Only
46
Scnr_46_Divide_Records_In_2_Half_Using_MV_WV
47
Scnr_47_Load_Data_Based_On_Runs
48
Scnr_48_Creating_Email_Id_From_Diff_Columns
49
Scnr_49_Breaking_Emailid_In_Diff_Columns
50
Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
21 Ratings

Detailed Rating

Stars 5
7
Stars 4
13
Stars 3
1
Stars 2
0
Stars 1
0
c16579c564151f90eb6c2239a39b5acd
30-Day Money-Back Guarantee

Includes

7 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion