Home Courses Instructor Labs

Informatica Interview Questions

(592 Ratings) 1992 Students Enrolled
Created By Saif Ali Last Updated Fri, 03-Jan-2020 English
  • Course Duration
    7 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    50 Lessons
  • Placement Assistance
    Guaranteed
Free
12k+ satisfied learners Read Reviews
What Will I Learn?
  • You will gain the potential to crack Informatica interviews
  • Learn how to approach the interview questions with practical explanations

Requirements
  • Basic understandings of Informatica ETL tool
+ View More
Description

50 Informatica ETL Interview scenarios practically solved which will help learners to enhance the skill and get more confident on concepts. This will helps to understand the logic written which helps you to grow technically and gives you the broader vision when a problem statement comes in front of you.

Informatica is one of the top technology which has lot more opportunities at Top MNCs. I ensure these 50 interview scenarios are most commonly asked in most of the interviews.

Curriculum For This Course
50 Lessons 7 Hours
  • Scenario 1: Converting Column to Rows 00:15:59 Preview
  • Scenario 2: Split NonKey Columns 00:05:19 Preview
  • Scenario 3: Generating SeqNo using Exp Trnfn 00:05:48
  • Scenario 4: Separating Dup NonDup Records 00:08:40
  • Scenario 5: Splitting Records Cyclic Order of 10 00:10:18
  • Scenario 6: Concatenating Values 00:08:54
  • Scenario 7: Cumulative Sum Salary 00:06:19
  • Scenario 8: Adding Previous Row Salary Only 00:07:17
  • Scenario 9: Generating Filename Dynamically 00:07:10
  • Scenario 10: Removing Dollar Sign 00:06:01
  • Scenario 11: Adding $ sign to Salary 00:05:26
  • Scenario 12: Using Mapping Parameter in ParamFile 00:07:07
  • Scenario 13: Sending Data one after another in three tables 00:07:29
  • Scenario 14: Count number of Vowels Consonants 00:08:44
  • Scenario 15: Removing Special Character 00:05:13
  • Scenario 16: Days Difference 2 Days 00:05:44
  • Scenario 17: Date Difference in Hours 00:04:32
  • Scenario 18: Adding Days to Date 00:05:11
  • Scenario 19: Display Emp Joined in Current Month & Date 00:07:33
  • Scenario 20: Extracting FNAME MNAME LNAME 00:08:55
  • Scenario 21: Convert Number Value to Date 00:06:12
  • Scenario 22: Checking Hiredate Column 00:05:38
  • Scenario 23: Separating H D F 00:21:11
  • Scenario 24: Dup NonDup in 2 Method 00:18:49
  • Scenario 25: Previous Row Salary Current Row 00:06:11
  • Scenario 26: Next Row Salary Current Row 00:06:53
  • Scenario 27: Sum of Salary Repeat on all Rows 00:06:12
  • Scenario 28: Concatenate Values per ID Column 00:06:23
  • Scenario 29: Concatenate all Values 00:06:17
  • Scenario 30: Concatenate Values ID Column only 00:06:10
  • Scenario 31: Slit Half Records into Separate Table 00:09:39
  • Scenario 32: Except Last 5 Records 00:10:30
  • Scenario 33: Split Odd Even Records 00:07:07
  • Scenario 34: Using Mapping Parameter in Paramfile 00:06:16
  • Scenario 35: Generate Seq via SQL Transf 00:08:56
  • Scenario 36: Generate FF Dynamically Deptno 00:11:26
  • Scenario 37: Load Multiple Files in Single File 00:14:13
  • Scenario 38: First Last Record Same Table 00:05:50
  • Sceanrio 39: First Last Record with One Agg Trnsf 00:07:33
  • Scenario 40: Replace Dollar with Rupee Sign 00:04:34
  • Scenario 41: Top 3 Salary Records without Rank Trnsf 00:05:54
  • Scenario 42: Extracting every 5th Row 00:04:27
  • Scenario 43: First 3 records 00:07:56
  • Scenario 44: Last 3 records 00:06:27
  • Scenario 45: Run 3rd Session After 3 Runs only 00:10:44
  • Scenario 46: Divide Records in 2 Half using MV_WV 00:17:33
  • Scenario 47: Load Data based on Runs 00:10:38
  • Scenario 48: Creating Email id from Diff Columns 00:04:57
  • Scenario 49: Breaking Emailid in Diff Columns 00:09:16
  • Scenario 50: Returning Multiple Values via Unconn Lkp 00:09:45

Informatica Interview Questions