If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / tauseef
hai Tauseef,
as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How identifying bottlenecks in various components of informatica and resolving them?
Define filter transformation?
What is union transformation in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Define Pmrep command?
Enlist the tasks for which source qualifier transformation is used.
define galaxy repository in informatica
How to differentiate between the active and passive transformations?
Can we create multiple integration service on single repository?
Performance tuning( what you did in performance tuning)
Briefly explain the aggregator transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
can u give example for factless fact table
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?