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 17786write 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 9823write 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 11615write 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 6748I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 117662write 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 8533If 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 12174My 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 11851What are your source in project and how you import in informatica? How can i explain abt this?
1 6501Post New Accenture Informatica Interview Questions
What are Services and Connectors in Pega?
What’s the usage of configuration interface in hibernate?
Does chkdsk f fix bad sectors?
Can we use Ambari Python Client to use of Ambari API’s?
What is test driver and test stub?
What are Routines?
Define the basic xml rules?
How do I insert a new page in word?
What are the uses of electroplating?
What happened if the exhaust valve is leaking?
what is vmodel?advantages and disadvantages of vmodel?
How do you tell if windows 10 is corrupted?
What is the purpose of sumifs in excel?
What is the homogenous?
How will you monitor the errors received while running i-server and report?