How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
No Answer is Posted For this Question
Be the First to Post Answer
What is workflow manager?
Write the unconnected lookup syntax?
How can you run a session without using server manager?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
During the running session, output files are created by informatica server. Enlist few of them.
what is Partitioning ? where we can use Partition?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
Why we use lookup transformations?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,