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
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the databases that informatica can connect to windows?
What is sorter transformation?
can we override a native sql query within informatica? How do we do it?
what is SDLC way of code development?
Enlist the advantages of informatica.
What are the different types of transformation available in informatica.
what is Active lock explain
What is a filter transformation and why it is an active one?
What is the use of transformation?
What are multi-group transformations?
Can u generate reports in Informatica?
Explain sessions and how many types of sessions are there?
EXL informatica Questions
What is informatica powercenter repository?