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
- 19045 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What you know about transaction control transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Why is sorter an active transformation?
How identifying bottlenecks in various components of informatica and resolving them?
Which transformation is needed while using the Cobol sources as source definitions?
In which transformation you cannot drag ports into it?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What do you mean incremental aggregation?
what is $$$$?
Target increases every day even though no new record was inserted
Did u used latest transformations of 8.6.0? for what?
Write the program through which the records can be updated?
