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
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 rank transform?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
Diffrence between 7.1,8.1 and 8.6
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What is an aggregator transformation? it is active why cant it be passive explain?
Explain lookup transformation source types in informatica
From where we can start or use pmcmd?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
How do you use reject loader.
How is Data Models Used in Practice?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...