what happens if the info.server doesn't find the session
parameter in the parameter file?
Difference between flat files and relational sources?
what is a test load?
Explain about hash partitioning?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are Lookup caches options? Including persistent caches.
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
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do u decide whether u need to do aggregations at database level or at Informatica level?
what happens if the info.server doesn't find the session parameter in the parameter file?
explain the methodology of Data Warehousing?(Polaries)
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.