write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
3 5793In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
1 4297write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
TCS,
2 4519write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
TCS,
1 4261If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
TCS,
1 6547Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
1 3362In what scenario we use to improve session performance by pushdown optimization?can any one give example?
2 5231Post New Informatica Questions
Different sorts of metadata that stores in the storage facility?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is informatica? Why do we need it?
draw informatica architecture 8.6 ?
Under which circumstances, informatica server creates reject files?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain incremental aggregation in informatica
Can u generate reports in Informatica?
How do you migrate data from one environment to another?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain lookup transformation source types in informatica
What are the components of workflow manager?
without table how to come first record only in oracle?
What is the cumulative sum and moving sum?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?