what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
2 8426Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
1716Hi, 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.
1801hoe to access second value in mapping parameter if it is having more than one value ?????????????
1538Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
3018can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
1800Hi 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
1519
what is pmrep command?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
how do u set partition points in the mapping?
how to connect to a flatfile through ftp in informatica
Compare ETL & Manual development?
What is etl tool in hadoop?
explain the methodology of Data Warehousing?(Polaries)
What is partitioning? Explain different types of partitioning?
what are the concerns of OLTP and DSS systems?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is a materialized view log?
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.
When do we go for the tools in the market?
In Which Transformation We Can Use Having Clause In Informatica?
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.