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

Answers were Sorted based on User's Feedback



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

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

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

Answer / nawin

Stage is mostly Truncate and load, also it is a full load concept.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / p

stage is a incremental load.we truncate existing data and load incremental data.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,


Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  


Informatica and datawarehousing courses in Pune?

2 Answers  


What are session parameters ? How do you set them?

0 Answers  






difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


what is mapping parameter and mapping variables

1 Answers   BirlaSoft,


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?

1 Answers  


What are the databases that informatica can connect to windows?

0 Answers  


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


why we use materialized view over view?

1 Answers   Zensar,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


Categories