how can we load starting with 11th record of a table from
source to target
- 6 Answers
- 8740 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akash
This scenario can also be implemented by using the
following query in Source Qualifier:
select * from table_name where rowid not in (select rowid
from table_name where rownum <= 10)
This will give the records after 10
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is fact table? Explain the different kinds of facts.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the Process to creating lookup transformation in informatica
Explain incremental aggregation in informatica
What is the Rank index port in Rank transformation?
server hot-ws270 is connect to Repository B. What does it mean?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
difference between repository database and repository service?
How do you change a non-reusable transformation to reusable transformation?
Enlist the various types of transformations.
