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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How will the document be delivered to me?
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
can u any challenge your project?
What is union transformation?
What are the different versions of informatica?
How to load a Dimension ? and how to load a fact table?
What is sequence generator transformation in informatica?
generate date / time dimension in informatica
Where can we find the throughput option in informatica?
how tokens will generate?
What you know about transaction control transformation?
On which transformations you created partitions in your project?
What is a difference between complete, stop and abort?
Reusable transformation and shortcut differences