If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
Answer Posted / anil
mr rao is answer is correct .another way use exp t/r put it
>1000
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
pmscmd startworkflow -sv
Separate from a database, an information bazaar, and an information stockroom?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the various types of transformation?
Define joiner transformation?
What could be the possible resons of locks by user?
How can we store previous session logs?
what is the -ve test case in your project.
can you please explain me pre session and post session options?
According to his methodology what all you need before you build a datawarehouse
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can we improve session performance in aggregator transformation?
Design time, run time. If you don't create parameter what will happen