Interested to Buy Any Domain ? << Click Here >> for more details...
Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 11515 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer Posted / joe
1. Use a sequence generator to associate a NEXTVAL to the
row.
2. Filter condition : NextVal <=20
For source- dbase: Do a filter at SQ by including the
following condition . WHERE Rownum <=20
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
What is workflow? What are the components of workflow manager?
How to create the source and target database connections in server manager?
Explain lookup transformation is active in informatica
Plz can any one say me how to get the informatica certification materials and dumps
Differentiate between sessions and batches?
What are the designer tools for creating transformations?
Explain scd type 3 through mapping.
What is meant by active and passive transformation?
what are the deliverables?in your project?
tell me the rules and responsblites in our project(my project is development)
What is the function of look up transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is INFORMATICA TESTING process
Explain the pipeline partition with real time example?
