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 do u implement scheduling in Informatica?
without using ETL tool can u prepare a Data warehousing and maintaining?
What is ROWID explain ?
What is etl process. How many steps etl contains explain with example?
WHY CANT WE SEE THE DATA IN DATASET
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is tracing level? How many types of transformations supported by sorted input?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Explain about enterprise scalability and roi of data integration suite?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
Explain different types of partitioning?
how do u set partition points in the mapping?