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.
when will use SQL override in a lookup transformation?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
how would u estimate the size of Aggregator transform data and index cache?
Is hadoop a etl tool?
what are the different Reporting and ETL tools available in the market?
how to load the data to fact table?
how do u extract data from different data sources explain with an example?
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.
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
what is the meant by Normalization and de-normalization?
what is different between sequential batch and concurrent batch and which is recommended and why?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.