How does the session recovery work.
Answer / isha
When sesiion fails and if we have configured it to resume from last checkpoint then IS creates checkpoints and save them in $PMStorageDir.
From there, it picks values and start session recovery.
| Is This Answer Correct ? | 0 Yes | 0 No |
when we dont use aggregator in mapping ?
How will u find weather dimension table is big in size of a fact table?
Can we create out put ports in source qualifier t/r?
Define maping and sessions?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
What is a router transformation?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
without table how to come first record only in oracle?
How to update or delete the rows in a target, which do not have key fields?