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 are the different types of olap? Give an example?
Clarify the aggregator change?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the difference between a connected look up and unconnected lookup?
Explain scd type 3 through mapping.
Global and Local shortcuts. Advantages.
What is InformaticaPowerCenter?
Differences between connected and unconnected lookup?
What is dimensional table? Explain the different dimensions.
Differentiate between reusable transformation and mapplet.
Explain about Informatica server process that how it works relates to mapping variables?
What will be the approach?
Explain the difference between a data warehouse and a data mart?
What are connected or unconnected transformations?
my source is junk data how will u remove that junk data by using unix please any one replay me