-
SCD Transformation
Can we use both SCD Type1 and Type2 transformations in one mapping? If yes how?
-
Unconnected lookup
Supose we have 4 column based on same condition can we use unconnected lookup in that case?
-
Typical Scenario - Schedule
Please help to set up following scenarioI have a source either file or db tableEno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2Want to run a session 3 times.First time: it should populate dept 1Second time: dept 2 onlyThird time: dept 3 onlyHow can we do this?
-
Duplicate Records
If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?
-
Scenario based
If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...