Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
50 Informatica Interview Scenarios - Solved
Rating: 4.4 out of 5(1,311 ratings)
9,473 students

50 Informatica Interview Scenarios - Solved

Informatica Scenarios Practically Solved with explanation.
Created bySaif Shaikh
Last updated 10/2024
English

What you'll learn

  • 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

Course content

1 section • 50 lectures • 6h 54m total length

  • Scnr_1_Converting_Column_to_Rows15:58
  • Scnr_2_Split_NonKey_Columns5:19
  • Scnr_3_Generating_SeqNo_Using_Exp_Trnfn5:48
  • Scnr_4_Separating_Dup_NonDup_Records8:39
  • Scnr_5_SplittingRecords_Cyclic_Orderof_1010:18
  • Scnr_6_Concatenating_Values8:53
  • Scnr_7_Cumulative_Sum_Salary6:19
  • Scnr_8_Adding_Previous_Row_Salary_Only7:16
  • Scnr_9_Generating_Filename_Dynamically7:09
  • Scnr_10_Removing_Dollar_Sign6:00
  • Scnr_11_Unique_City_Distance5:08
  • Scnr_12_Using_Mapping_Parameter_in_ParamFile7:07
  • Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls7:29
  • Scnr_14_Count_No_of_Vowels_Consonants8:43
  • Scnr_15_Removing_Special_Char5:13
  • Scnr_16_Days_Difference_2_Days5:44
  • Scnr_17_Date_Difference_in_Hrs4:31
  • Scnr_18_Adding_Days_to_Date5:11
  • Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year7:32
  • Scnr_20_Extracting_FNAME_MNAME_LNAME8:55
  • Scnr_21_Convert_Number_Value_to_Date6:12
  • Scnr_22_Checking_Hiredate_Column5:37
  • Scnr_23_Separating_H_D_F21:10
  • Scnr_24_Dup_NonDup_in_2_Method18:48
  • Scnr_25_Previous_Row_Salary_Current_Row6:10
  • Scnr_26_Next_Row_Sal_Curr_Row6:53
  • Scnr_27_Sum_of_Sal_Repeat_On_All_Rows6:11
  • Scnr_28_Concatenate_Values_Per_ID_Column6:22
  • Scnr_29_Concatenate_All_Values6:16
  • Scnr_30_Concatenate_Values_ID_Column_Only6:10
  • Scnr_31_Slit_Half_Records_Into_Separate_Table9:38
  • Scnr_32_Except_Last_5_Records10:29
  • Scnr_33_Split_Odd_Even_Records7:07
  • Scnr_34_Use_Mapping_Parameter_In_Paramfile6:16
  • Scnr_35_Generate_Seq_via_SQL_Transf8:55
  • Scnr_36_Generate_FF_Dynamically_Deptno11:25
  • Scnr_37_Load_Mutliple_Files_In_Single_File14:12
  • Scnr_38_First_Last_Record_Same_Table6:52
  • Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf7:32
  • Scnr_40_Replace_Dollar_With_Rupee_Sign4:34
  • Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf5:54
  • Scnr_42_Extracting_Every_5th_Row4:26
  • Scnr_43_First_3_Records7:55
  • Scnr_44_Last_3_Records6:27
  • Scnr_45_Run_3rd_Session_After_3_Runs_Only13:12
  • Scnr_46_Divide_Records_In_2_Half_Using_MV_WV17:33
  • Scnr_47_Load_Data_Based_On_Runs10:38
  • Scnr_48_Creating_Email_Id_From_Diff_Columns4:57
  • Scnr_49_Breaking_Emailid_In_Diff_Columns9:16
  • Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp9:45

Requirements

  • Understanding of Informatica ETL Tool

Description

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.

Who this course is for:

  • Anyone who wants to learn Informatica ETL and get Practical Hands on Interview Scenarios

Report abuse