Is it possible to update the target table with PK?
Answer / vikram
You needs to use PK for updating the Target table along
with the Update Strategy and select Datadriven @ session
level.
| Is This Answer Correct ? | 20 Yes | 2 No |
What is a stored procedure transformation?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to update or delete the rows in a target, which do not have key fields?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What are Rapid changing dimensions?
how many ways can we implement SCD2?
what is the method of error handling when session is running?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
How will you display "Mr" for male & "Mrs" for female in target table?
Where do you create/define mapping parameter and mapping variable?