50 个 Informatica 面试场景 - 已解决
50 Informatica Interview Scenarios - Solved
- 001 Scnr_1_Converting_Column_to_Rows
- 002 Scnr_2_Split_NonKey_Columns
- 003 Scnr_3_Generating_SeqNo_Using_Exp_Trnfn
- 004 Scnr_4_Separating_Dup_NonDup_Records
- 005 Scnr_5_SplittingRecords_Cyclic_Orderof_10
- 006 Scnr_6_Concatenating_Values
- 007 Scnr_7_Cumulative_Sum_Salary
- 008 Scnr_8_Adding_Previous_Row_Salary_Only
- 009 Scnr_9_Generating_Filename_Dynamically
- 010 Scnr_10_Removing_Dollar_Sign
- 011 Scnr_11_Unique_City_Distance
- 012 Scnr_12_Using_Mapping_Parameter_in_ParamFile
- 013 Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls
- 014 Scnr_14_Count_No_of_Vowels_Consonants
- 015 Scnr_15_Removing_Special_Char
- 016 Scnr_16_Days_Difference_2_Days
- 017 Scnr_17_Date_Difference_in_Hrs
- 018 Scnr_18_Adding_Days_to_Date
- 019 Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year
- 020 Scnr_20_Extracting_FNAME_MNAME_LNAME
- 021 Scnr_21_Convert_Number_Value_to_Date
- 022 Scnr_22_Checking_Hiredate_Column
- 023 Scnr_23_Separating_H_D_F
- 024 Scnr_24_Dup_NonDup_in_2_Method
- 025 Scnr_25_Previous_Row_Salary_Current_Row
- 026 Scnr_26_Next_Row_Sal_Curr_Row
- 027 Scnr_27_Sum_of_Sal_Repeat_On_All_Rows
- 028 Scnr_28_Concatenate_Values_Per_ID_Column
- 029 Scnr_29_Concatenate_All_Values
- 030 Scnr_30_Concatenate_Values_ID_Column_Only
- 031 Scnr_31_Slit_Half_Records_Into_Separate_Table
- 032 Scnr_32_Except_Last_5_Records
- 033 Scnr_33_Split_Odd_Even_Records
- 034 Scnr_34_Use_Mapping_Parameter_In_Paramfile
- 035 Scnr_35_Generate_Seq_via_SQL_Transf
- 036 Scnr_36_Generate_FF_Dynamically_Deptno
- 037 Scnr_37_Load_Mutliple_Files_In_Single_File
- 038 Scnr_38_First_Last_Record_Same_Table
- 039 Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf
- 040 Scnr_40_Replace_Dollar_With_Rupee_Sign
- 041 Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf
- 042 Scnr_42_Extracting_Every_5th_Row
- 043 Scnr_43_First_3_Records
- 044 Scnr_44_Last_3_Records
- 045 Scnr_45_Run_3rd_Session_After_3_Runs_Only
- 046 Scnr_46_Divide_Records_In_2_Half_Using_MV_WV
- 047 Scnr_47_Load_Data_Based_On_Runs
- 048 Scnr_48_Creating_Email_Id_From_Diff_Columns
- 049 Scnr_49_Breaking_Emailid_In_Diff_Columns
- 050 Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp