Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34061 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sathish
source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a node in Informatica?
Define update strategy?
What are the modules in Power Center
Explain Dataware house architecture .how data flow from intial to end?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Is stop and abort are same in informatica?
What are the informatica performance improvement tips
What is Session and Batches?
Which is the t/r that builts only single cache memory?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the complex transformation you used in informatica
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How many dimensions are there in informatica?
What are the different ways to implement parallel processing in informatica?
