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 17673write 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 9714write 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 11457write 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 6614I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 115054write 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 8414If 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 12004My 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 11667What are your source in project and how you import in informatica? How can i explain abt this?
1 6446Post New Accenture Informatica Interview Questions
Can we assign string to char pointer?
What is a console operator?
What are your favorites subjects in your graduation and why?
What are the considerations for using group by clause?
Is inflation good or bad for the economy?
How can you include data item in an expression?
Difference between static synchronization vs. Instance synchronization?
What is javax swing joptionpane?
What makes c shell a more preferable option than the bourne shell?
What is a nested loop?
Why do you create or replace procedures rather that drop and recreate.
What are the different types of services provided to the customers?
What is the advantage of creating the acbs well ahead of time?
How do I connect to a postgresql database?
Why is jsf not as popular as, for example, mvc frameworks like spring mvc, although jsf is older and included in jee?