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
Explain dynamic target flat file name generation in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain the shared cache and re-cache?
Explain lookup transformation in informatica
What is a mapplet/worklet in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
What are the measure objects?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is intricate mapping?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can we handle two sessions in informatica?
What is joiner transformation?
Can anyone tell me the new features in Informatica 9 Version?
What could be the possible resons of locks by user?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?