how do u decide whether u need to do aggregations at
database level or at Informatica level?
Answer / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
| Is This Answer Correct ? | 0 Yes | 0 No |
How many steps etl contains explain with example?
What do you understand by the term ‘transformation’?
What is the difference between round-robin partitioning and hash partitioning?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
WHY CANT WE SEE THE DATA IN DATASET
flat filevalidation in informatica
where is the cache (lookup, index) created and how can you see it.
how would u estimate the size of Aggregator transform data and index cache?
Explain the difference between etl tool and olap tools?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
How many steps etl contains?