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 |
how we can load rejected record's at run time?(not through bad files)
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Why do you use Mapping Parameter and mapping variable?
What is rank transformation in informatica
How can you change from reusable session into non-reusable session.
WHAT IS FACT TABLES?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
"Change cache" in Informatica ?
Is it possible to use a client with different version than that of its Informatica server?
What is confirmed fact in dataware housing?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?