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 |
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
What are batches?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What is metadata reporter?
What is data movement mode in Informatica and difference between them?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
What is the difference between lookup override and souce qualifier override ?
What are the advantages of informatica?
How to generate sequence numbers?
Can we call a stored procedure from a unix script which is run using command task
What is different between informatica version 8 and 9 version
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?