Interested to Buy Any Domain ? << Click Here >> for more details...
If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
- 5 Answers
- 19097 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
simple. in session properties configure the session to
enable recovery. it then create s a database log file which
contains the rowids ot all records committed to the target.
when you run recovery session it checks with the log file
the last rowid committed to the target and writes to the
target from the next rowid. condition the session is
configured to run in a normal mode.
| Is This Answer Correct ? | 42 Yes | 0 No |
Answer / rao
one option is session recovery.
or
select * from select rownum from tablenaem) where rownum>10000
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / mohit
After running the session once it will load 10000 records
and it will fail afterwards then we can take the minimum
and maximum count of the number of records in the target in
a paramter and we can specify these parameters in the SQl
override of sql qualifier so once again when it will run
the session then it will take those minimum and maximum
values from the parameter and will specify a condition in
the sql overide that dont take any values from min to max
and take rest of the values so in this case the minimum
will be 1 and the maximum will be 10000 so the sql overide
will take the values after 10000 i.e 10001.
select * from employee where value is not in between $$min
and $$max
I think may be this can be a solution
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anil
mr rao is answer is correct .another way use exp t/r put it
>1000
| Is This Answer Correct ? | 0 Yes | 7 No |
how can you load data into target table without leading zeor's
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Explain sessions. Explain how batches are used to combine executions?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
how do u tune queries?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What happens when a session fails and you click on recover?
What are the different types of code pages available in informatica & how to implement it in your project?
How can repository reports be accessed without sql or other transformations?
How to handle changing source file counts in a mapping?
Teradata 
