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 |
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Explain the features of connected and unconnected lookup.
How many numbers of sessions can one group in batches?
What are the types of presistent cache in look up tr.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
can you avoid static cache in the lookup transformation? I mean can you
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
What is Index Caches size?
Write the different tools in the workflow manager?
can you use flat file for repository?why?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
difference between stop and abort