آموزش 50 سناریو مصاحبه انفورماتیکا - حل شد

سناریوهای مصاحبه Informatica ETL Informatica ETL Interview Scenarios

• Scnr_1_Converting_Column_to_Rows Scnr_1_Converting_Column_to_Rows

• Scnr_2_Split_NonKey_Columns Scnr_2_Split_NonKey_Columns

• Scnr_3_Generating_SeqNo_Using_Exp_Trnfn Scnr_3_Generating_SeqNo_Using_Exp_Trnfn

• Scnr_4_Separating_Dup_NonDup_Records Scnr_4_Separating_Dup_NonDup_Records

• Scnr_5_SplittingRecords_Cyclic_Orderof_10 Scnr_5_SplittingRecords_Cyclic_Orderof_10

• Scnr_6_Concatenating_Values Scnr_6_Concatenating_Values

• Scnr_7_Cumulative_Sum_Salary Scnr_7_Cumulative_Sum_Salary

• Scnr_8_Adding_Previous_Row_Salary_Only Scnr_8_Adding_Previous_Row_Salary_Only

• Scnr_9_Generating_Filename_Dynamically Scnr_9_Generating_Filename_Dynamically

• Scnr_10_Removing_Dollar_Sign Scnr_10_Removing_Dollar_Sign

• Scnr_11_Unique_City_Distance Scnr_11_Unique_City_Distance

• Scnr_12_Using_Mapping_Parameter_in_ParamFile Scnr_12_Using_Mapping_Parameter_in_ParamFile

• Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls Scnr_13_Sending_Data_One_After_Another_in_Three_Tbls

• Scnr_14_Count_No_of_Vowels_Consonants Scnr_14_Count_No_of_Vowels_Consonants

• Scnr_15_Removing_Special_Char Scnr_15_Removing_Special_Char

• Scnr_16_Days_Difference_2_Days Scnr_16_Days_Difference_2_Days

• Scnr_17_Date_Difference_in_Hrs Scnr_17_Date_Difference_in_Hrs

• Scnr_18_Adding_Days_to_Date Scnr_18_Adding_Days_to_Date

• Scnr_19_Display_Emp_joined_in_Curr_Month_&_Year Scnr_19_Display_Emp_Joined_in_Curr_Month_&_Year

• Scnr_20_Extracting_FNAME_MNAME_LNAME Scnr_20_Extracting_FNAME_MNAME_LNAME

• Scnr_21_Convert_Number_Value_to_Date Scnr_21_Convert_Number_Value_to_Date

• Scnr_22_Checking_Hiredate_Column Scnr_22_Checking_Hiredate_Column

• Scnr_23_Separating_H_D_F Scnr_23_Separating_H_D_F

• Scnr_24_Dup_NonDup_in_2_Method Scnr_24_Dup_NonDup_in_2_Method

• Scnr_25_Previous_Row_Salary_Current_row Scnr_25_Previous_Row_Salary_Current_Row

• Scnr_26_Next_Row_Sal_Curr_Row Scnr_26_Next_Row_Sal_Curr_Row

• Scnr_27_Sum_of_Sal_Repeat_On_All_Rows Scnr_27_Sum_of_Sal_Repeat_On_All_Rows

• Scnr_28_Concatenate_Values_Per_ID_Column Scnr_28_Concatenate_Values_Per_ID_Column

• Scnr_29_Concatenate_All_Values Scnr_29_Concatenate_All_Values

• Scnr_30_Concatenate_Values_ID_Column_Only Scnr_30_Concatenate_Values_ID_Column_Only

• Scnr_31_Slit_Half_Records_Into_Separate_Table Scnr_31_Slit_Half_Records_Into_Separate_Table

• Scnr_32_Except_Last_5_Records Scnr_32_Except_Last_5_Records

• Scnr_33_Split_Odd_Even_Records Scnr_33_Split_Odd_Even_Records

• Scnr_34_Use_Mapping_Parameter_In_Paramfile Scnr_34_Use_Mapping_Parameter_In_Paramfile

• Scnr_35_Generate_Seq_via_SQL_Transf Scnr_35_Generate_Seq_via_SQL_Transf

• Scnr_36_Generate_FF_Dynamically_Deptno Scnr_36_Generate_FF_Dynamically_Deptno

• Scnr_37_Load_Mutliple_Files_In_Single_File Scnr_37_Load_Mutliple_Files_In_Single_File

• Scnr_38_First_Last_Record_Same_Table Scnr_38_First_Last_Record_Same_Table

• Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf Scnr_39_Firt_Last_Record_With_One_Agg_Trsnf

• Scnr_40_Replace_Dollar_With_Rupee_Sign Scnr_40_Replace_Dollar_With_Rupee_Sign

• Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf Scnr_41_Top_3_Sal_Records_Without_Rank_Trsnf

• Scnr_42_Extracting_Every_5th_Row Scnr_42_Extracting_Every_5th_Row

• Scnr_43_First_3_Records Scnr_43_First_3_Records

• Scnr_44_Last_3_Records Scnr_44_Last_3_Records

• Scnr_45_Run_3rd_Session_After_3_Runs_Only Scnr_45_Run_3rd_Session_After_3_Runs_Only

• Scnr_46_Divide_Records_In_2_Half_Using_MV_WV Scnr_46_Divide_Records_In_2_Half_Using_MV_WV

• Scnr_47_Load_Data_Based_On_Runs Scnr_47_Load_Data_Based_On_Runs

• Scnr_48_Creating_Email_Id_From_Diff_Columns Scnr_48_Creating_Email_Id_From_Diff_Columns

• Scnr_49_Breaking_Emailid_In_Diff_Columns Scnr_49_Breaking_Emailid_In_Diff_Columns

• Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp Scnr_50_Returning_Multiple_Values_Via_Unconn_Lkp