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 16552write 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 8451write 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 9818write 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 5824I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 94394write 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 7255If 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 10278My 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 9883What are your source in project and how you import in informatica? How can i explain abt this?
1 5778Post New Accenture Informatica Interview Questions
What does a 'MapReduce Partitioner' do?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what are the minimum requirements for statr testing?
What is JSF Navigation Rule?
What are web tabs?
What is bug leakage?
Explain ovarian cysts. What harm can they do?
Tell us what is ics?
Give an example of p-value?
How data locks are respected in oracle?
What are the different spring frameworks?
Is a windows 10 iso free?
Do closed loops systems require manual input?
How is unit test done in python?
What is a physical tag and logical tag in html?