Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 5 Answers
- 16273 Views
- I also Faced
- E-Mail Answers
Post New Answer View All Answers
Define Dynamic push down optmization?
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.
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how do u set partition points in the mapping?
Do we need an etl tool?
how does the server recongnise the source and target databases.Elaborate on this
list and discuss two approaches for updation of target table in Informatica and how they are different.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are the various tools used in etl?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Is hadoop a etl tool?
What are the ETL Testing Operations?
How etl testing is different from database testing?
how would u estimate the size of Aggregator transform data and index cache?
