Questions asked in F2F. 1) Tell about yourself on professional experience, tools used and current project working on. 2) Explain about the Type 2 SCD model 3) we have 10 mapping in different folder, all these 10 mapping has same target table (lets say employee table). Using Sequence Generator transformation we need to generate the (employee id) surrogate key. Now the scenario is, when First mapping executed 10 records passed to TGT table. When second mapping executed another 5 records passed to TGT table. In this scenario how the surrogate key is handled. 4) Question on flat file as below
SOURCE (FLAT FILE)
EMP_NO DEPT_NO SALARY
10 101 1000
20 102 2000
30 103 3000
40 102 4000
50 101 5000
60 104 6000
TARGET(FLAT FILE)
EMP_NO DEPT_NO SALARY
10 101 1000
50 101 5000
6000
20 102 2000
40 102 4000
6000
30 103 3000
3000
60 104 6000
6000
so in the target salary column, we need to sum up the salary based upon the dept_no.
5)SOURCE (FLAT FILE)
ID VALUE
1 A
2 B
3 C
4 D
5 E
TARGET(FLAT FILE)
ID VALUE PRE_VALUE
1 A B
2 B C
3 C D
4 D E
5 E NULL
How we can achieve this using Informatica?
6) SQL Scenario Question
COL_A COL_B
10 A
20 B
30 C
40 D
When we select 10 from COL_A using WHERE clause filter, the output should display A from COL_B.
When we select 30 from COL_A using WHERE clause filter, the output should display C from COL_B.
Similarly when we select 50(which is not available in COL_A) then it should display "Invalid Number".
How to achieve this using Sql.