Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / praveen
You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is rank transform?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain scd type 3 through mapping.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How might one distinguish in the case of mapping is right or not without associating session?
How to join three sources using joiner?
Explain how to import oracle sequence into informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is a predefined event?
How union transformation is used?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
While migrating the data from one environment to another environment how would you manage the connections?
What are mapplets?
Why update strategy and union transformations are active? Explain with examples.
generate date / time dimension in informatica