Interested to Buy Any Domain ? << Click Here >> for more details...
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
- 3 Answers
- 7481 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
Depends for what purpose are you using your staging table.
In some cases we ll use a Landing table(Truncate and load) just before Staging(SCD1). In cases where we wont use such landing tables Staging will be Truncate and Load.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nawin
Stage is mostly Truncate and load, also it is a full load concept.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / p
stage is a incremental load.we truncate existing data and load incremental data.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is A cache?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
difference between source based commit? and target based commit? which is better with respect to performance?
What is meant by active and passive transformation?
What is Datadriven?
What is a dimensional model?
Explain sessions and how many types of sessions are there?
How many repositories can be created in informatica?
How many joins in Informatica
How to load last n records of file into target table - informatica
What are the Advantages of de normalized data?
How to load a relational source into file taget?
Teradata 
