can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 17643write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
4 9679write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
5 11389write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
2 6562I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 114419write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
3 8376If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
6 11939My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
6 11612What are your source in project and how you import in informatica? How can i explain abt this?
1 6422Post New Accenture Informatica Interview Questions
in dc shunt motor if field winding is shorted then
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is the purpose of ios::basefield in the following statement?
Explain access modifiers in java.
what is SCR (Silicon Controlled Rectifier)?
You want to update the progress in wbs elements. How would you do that?
What is the maximum strength of cub compress strength in one cub testing
how do you react to instruction and criticism?
Can we insert data in view oracle?
Guest expenses Rs 5500/-on behalf of partner Aravind was written as Hospitality. Rectify it
What is the structure of the http response
What are the application areas that use validation and substitutions?
What is css and what are its advantages?
How to display error messages in JSF?
what is the height of tree if leaf node is at level 3. please explain