What are various etl tools in the market?

523

Define Dynamic push down optmization?

1907

what are the production issues in datastage?

9736

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1627

Identifying the bottlenecks in various components of Informatica and resolving them.

2170

what is data modeling?

1461

What are three tier systems in etl?

616

What is etl process?

530

Can u access a repository created in previous version of Informatica?

1466

how many maximum session supports to multiload in teradata ??

1692

State the differences between shortcut and reusable transformation

513

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?

1447

dimension object created in oracle can be imported in designer?how?

2453

What is virtual Data Warehousing?

548

tell me few points when u become TL

2021