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 to extract original records at one target & Duplicate records at one target?
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What is difference between stored procedure transformation and external procedure transformation?
What is galaxy shema
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Which is the best place to learn Informatica Powercenter Online Training?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
How to generate a single mapping for both the historical and incremental load.
Difference between task flow and linear task flow
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?