sample mappings for scd1,scd2 and scd3
Answers were Sorted based on User's Feedback
Answer / vemuri vijay
steps
go to mappings
go to wizards
there is two optins
1.getting started
2.scd
go to scd
again three types
type1
type2
type3
select ur requirement
ex.
take type1
select source table and give name for target table
then
next
give target table fields
then
finish
automatically u will get mapping
go to
workflow manager
create
task and
worklet
start task
thats all
Is This Answer Correct ? | 12 Yes | 7 No |
Answer / nikhil tiwari
check this site for SCD-2 step by step implementation:
http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html
Is This Answer Correct ? | 0 Yes | 0 No |
How will you update the row without using update statergy?
what is the difference between stop and abort?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
What are events in workflow manager?
How to fix the etl bugs..Tell me the process?
Differentiate between reusable transformation and mapplet.
how i will stop my workflow after 10 errors
What is the sequence generator transformation in informatica?
What is a pre-defined event and user-defined event?
All active transformations r passive or not?