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 |
what type of transformation is not supported by mapplets?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
wat s mapping parameter and mapping variable? how do you set that in a mapping?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
what are challenges that you faced in testing? give solution to it?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is lookupoverriding?
Explain about cumulative Sum or moving sum?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
How can informatica be used for an organization?
What is persistent lookup cache?