what are cost based and rule based approaches and what is
the difference?
How can i send first half of the records to one target and Remaining to other target?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
what is degenerated dimension
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
How to delete duplicate row using informatica?
What is decode in static cache?
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
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.