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
- 14071 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / jacob
take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a connected transformation?
What does update strategy mean, and what are the different option of it?
What is Index Caches size?
What do you mean by channel change?
How many types of sessions are there in informatica.please explain them?
Differentiate between source qualifier and filter transformation?
How do you load first and last records into target table?
Enlist the various types of transformations.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the size of u r source(like file or table)?
In development project what is the process to follow for an etl developer from day1
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?
How to create Target definition for flat files?
Explain sessions?
How are the sources and targets definitions imported in informatica designer?
