Explain scd type 3 through mapping.
No Answer is Posted For this Question
Be the First to Post Answer
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
what is target update override and when we use it?
what is casual dimension?
How to retrieve last two days updated records?
What is data transformation manager process?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How do you update the records with or without using update strategy?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What is Data Caches size?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What is the difference between router and filter?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source