in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / pavana
You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to create the source and target database connections in server manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
r u done any partitions in ur project?
What are the components of Informatica? And what is the purpose of each?
Explain sessions and how many types of sessions are there?
what is mean by complex business rule ?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the use of source qualifier?
How many input parameters can exist in an unconnected lookup?
Mention few power centre client applications with their basic purpose?
What is joiner change?
What is dynamic cache?
Explain the use of aggregator cache file?
Explain the features of connected and unconnected lookup.