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
- 13851 Views
- L&T, I also Faced
- E-Mail Answers
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 the Default Source Option For Update Strategy Transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is an Integration service in Informatica?
How do you migrate data from one environment to another?
list out all the transformations which use cache?
what are the Methods For Creating Reusable Transformations?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the use of an aggregator cache file?
What is the use of target designer?
Define mapplet?
What are the types of caches in lookup? Explain them.
What are the types of data warehouses?
State the differences between sql override and lookup override?
What the difference is between a database, a data warehouse and a data mart?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
