i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are mapplets? How is it different from a Reusable Transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain pmcmd command usage in informatica
Does an informatica transformation support only aggregate expressions?
can we override a native sql query within informatica? Where do we do it?
What is primary and backup node?
How to differentiate between the active and passive transformations?
What is the difference between informatics 7x and 8x and what is latest version?
What are the different components of powercenter?
complex mapping ur project u r invlve can u explain and give real time example give me ?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
what are the Methods For Creating Reusable Transformations?
Is it possible to revert a global repository to local one and why?
What is rank transformation?