how can we load starting with 11th record of a table from
source to target
Answer Posted / prabhu
If it a flat file u can use initial no of rows to skip
property while creating source definition.We can set it to
11 so that informatica will skip 11 rows while reading from
source
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is intricate mapping?
What is a grid in Informatica?
COM components can be used in Informatica
According to his methodology what all you need before you build a datawarehouse
What is InformaticaPowerCenter?
Enlist some properties of sessions.
What do you mean by blocking transformation?
What is sorter transformation?
How to partition the Session?
How might you approve all mappings in the archive all the while?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Clarify the aggregator change?
What is workflow manager?
Explain the shared cache and re-cache?