Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you set a varible in incremental aggregation

1440


What is a repository? And how to add it in an informatica client?

644


What do you mean by worklet?

624


What are pre and post-session shell commands?

735


What is rank transform?

595






Can u generate reports in Informatica?

651


Explain the informatica workflow?

582


Explain pushdown optimization $pushdownconfig parameter - informatica

695


How do you convert single row from source into three rows into target?

599


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1584


Difference between Data and Index Caches?

647


EXL informatica Questions

929


What are the different ways to implement parallel processing in informatica?

858


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1689


How can a transformation be made reusable?

658