Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
Latest Answer: You can do it by performing session recovery.When you enable session recovery option, the integration service makes the entries to opb_session_recovery table and notes the row id of the last row committed to the target. When you run the session again ...
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
Latest Answer: By viewing session.log file-Target load summary ...
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps
Latest Answer: as u wish to run the workflow frm the second session, just go to workflow manager,right click on the session that u wish the begin the sequence from and click on 'start workflow from task' ...
What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .
Latest Answer: Yes they are same , But suppose if we define Same variable in Session and mapping with some value then Informatica will take Value which has been defined in Session ...
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
Latest Answer: We should consider cardinality (lesser number of unique records) on joining conditions for master rather then falling into straight statistics of rowcounts..!!-- Sam ...
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
Latest Answer: Plus we can use 5 pass through PARTITIONS as 5 files will be read concurrently ...
What are Grain Facts?
Latest Answer: Deepak's answer is correct - just rewording the way I see it. Grain of the fact table represents the most granular information you can get from that table. Typically it is the combination of the different dimensions present in the fact table. So, ...
What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?
Latest Answer: definitely it accepts the defualt values when parameters or variables are not present. ...
What is Assignment task in informatica? In what situation this task will be executed? Where this task exits?
Latest Answer: The Assignment task allows you to assign a value to a user-defined workflow variable. To use an Assignment task in the workflow, first create and add the Assignment task to the workflow. Then configure the Assignment task to assign values or expressions ...
Latest Answer: staging Area where we transform the source data into meaningful data ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
