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
- 14080 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
how to load dimension table and fact table. plz tell me the steps.
waht type of interface is used for testing the data in informatica
Enterprise data warehouse your projects phase by phase explain?
What are the various types of transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can you generate sequence numbers without using the sequence generator transformation?
what is informatica metadata?
How do you change a non-reusable transformation to reusable transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can you validate all mappings in the repository simultaneously?
Difference between Target-based loading and constraint-based loading?
What are the tasks that source qualifier perform?
What are the designer tools for creating transformations?
What is data caches/ index caches?
what are 3 tech challenges/ common issues you face?
