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 17638write 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 9672write 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 11382write 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 6547I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 114251write 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 8363If 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 11932My 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 11585What are your source in project and how you import in informatica? How can i explain abt this?
1 6414Post New Accenture Informatica Interview Questions
Mention the difference between an object and a class ?
What are the GL postings in Stock revaluation and stock adjustment transactions?
What do you mean by operator overloading?
Can wildcards be used in authorizations?
Explain the difference in record set and dataset?
What are the browser related issues for jQuery?
What are browser events?
States some of the tool bars used in cad?
What is @ngmodule?
The stress concentration is caused due to ?
What interface must an object implement before it can be written to a stream as an object?
Difference between array and array collection?
What is mandatory property of app.engine?
How do I add a primary key to a table?
How to use update statement in laravel?