Can u access a repository created in previous version of
Informatica?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Explain about enterprise scalability and roi of data integration suite?
What is meant by incremental load?
Explain about hash partitioning?
Do we need an etl tool?
Explain the use lookup tables and Aggregate tables?
Explain about power designer data modeling software?
what is the use of structures?how many nodes can u create in a structure?
What is full load & incremental or refresh load?
Can u access a repository created in previous version of Informatica?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
SCD2 will work on only dimension tables as well as fact Table?