| Other Informatica Interview Questions |
|| Asked @
|write 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
|In SCD type 2 if we had select date range.
then suppose we had inserted today's date(eq. date is 30 aug
2010) then start date will be today's date(30 aug 2010)
what will be the end date,we cant leave it blank?
|write a query to get maximum salary from the employers table
without duplicates....kindly help me
|How to load a relational source into file taget?
|How to recover the standalone session?
|difference between top down(w.h inmon)and bottom up(ralph
|I am hvaing SOURCE as
Now i want the OUTPUT as
For more clarification i want to elimate nulls and want in
a single line.
Please help me out
|how to identify new and old values in source qualifier or
any other transformations using informatica
|How to fasten loading of 100 million distinct records in
(Initially they are loaded into target without using any
transformation, taking 2 hours)
|What is power play plug in?
|Which kind of index is preferred in DWH?
|how do u use sequence created in oracle in informatica?
Explain with an simple example
|For more Informatica Interview Questions Click Here |