i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11731 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 are the various types of transformation?
What are the types of data warehouses?
how to load rows into fact table in data warehouse
Can anyone tell me the new features in Informatica 9 Version?
What is parallel processing in informatica?
What are the differences between joiner transformation and source qualifier transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
write a query to retrieve the latest records from the table sorted by version(scd)
What is workflow manager?
How can we remove the duplicates from flat file source?
What is a joiner transformation?
What are mapplets? How is it different from a Reusable Transformation?
Scheduling properties,whats the default (sequential)
Explain the pipeline partition with real time example?
Explain about cumulative Sum or moving sum?
