Interested to Buy Any Domain ? << Click Here >> for more details...
In SCD type 2 if we had select date range.
then suppose we had inserted today's date(eq. date is 30 aug
2010) then start date will be today's date(30 aug 2010)
what will be the end date,we cant leave it blank?
- 2 Answers
- 8137 Views
- Cognizant, emc2, I also Faced
- E-Mail Answers
Answer Posted / venubyna1
when ll we insert the data into target the systam date
insert into start date and in end date null
tomarrow we insert 50 rec into target table in that 25
update 25 new.
update rec inserting as a new rec(target table contain 50
rec and update as insert means 25 rec inserting from 51)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the use of target designer?
What is the difference between router and filter?
Which transformation is needed while using the Cobol sources as source definitions?
Describe the impact of several join conditions and join order in a joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the status code in stored procedure transformation?
Can you use flat files in Mapplets.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
wf dont have integration severances how you can run?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by incremental aggregation?
What is sorter transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
