i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
Answer Posted / sameer
If our source as a relational table then we write sql queries in sour economy qualifier transformation select * from table-name where rownum <=7
But if our soure as flat file
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is status code in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can you use flat files in Mapplets.
Design time, run time. If you don't create parameter what will happen
Enlist the tasks for which source qualifier transformation is used.
How to create or import flat file definition in to the warehouse designer?
How is union transformation utilized?
While migrating the data from one environment to another environment how would you manage the connections?
Explain the scenario which compels informatica server to reject files?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is InformaticaPowerCenter?
What is domain in terms of informatica?
What are the designer tools for creating transformations?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the types of lookup transformation?