Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
3 6855In 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 5093write 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 5439write 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 5104If 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 7263Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
1 4092In what scenario we use to improve session performance by pushdown optimization?can any one give example?
2 6178Post New Informatica Questions
What is option by which we can run all the sessions in a batch simultaneously?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is fact table? Explain the different kinds of facts.
Separate from an archive server and a powerhouse?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is deployment group?
Which development components of informatica have the highest usage?
What does command task mean?
Can we get 1st record through Informatica(without sequence number).
How to create or import flat file definition in to the warehouse designer?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Define mapplet?
What is informatica metadata and where is it stored?
What are ETL Tools?
How to generate sequence numbers without using the sequence generator transformation?
