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 do you update the records with or without using update strategy?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What is the need for an etl tool?
What is primary and backup node?
What is Java Transformation? what are the uses of it?
How do you remove duplicate records in informatica?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
What is informatica etl tool?
Explain what transformation and how many are there in informatica?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Different sorts of metadata that stores in the storage facility?