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
- 13497 Views
- L&T, I also Faced
- E-Mail Answers
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
How identifying bottlenecks in various components of informatica and resolving them?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
difference between repository database and repository service?
How do we call shell scripts from informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
where to store informatica rejected data?
What is a repository manager?
How to handle decimal places while importing a flatfile into informatica?
can u any challenge your project?
How can we handle two sessions in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a pre-defined event and user-defined event?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What all are steps in up gradation of Informatica server?
