Interested to Buy Any Domain ? << Click Here >> for more details...
i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 13844 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / vijay
Are you saying you want the first 7 records from the source
table?
If that is the case, write an override in source qualifier
and fetch by the row number. That would be the fastest
way.Load into target.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
What is a filter transformation?
What is informatica powercenter repository?
Why update strategy and union transformations are active?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you change a non-reusable transformation to reusable transformation?
What is the advantage of informatica?
What is rank transform?
What is the difference between Active and Passive transformation?
How do we call shell scripts from informatica?
What is standalone command task?
What are the components of the workflow manager?
Please let me know how to make encryption and decryption with example?
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 we use the mapping parameters or variables created in one mapping into any other reusable transformation?
