write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
Answer Posted / vikram
Hey are you guys not informatica resource.. why do you post
answer when you dont know answer.
I have seen this question on many pages and ans give as
Normalizer.
Guys: Correct answer is to use Aggregator..
Normalize : converts rows to column
Agg : Can convert columns to row
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
I have a flat file, want to reverse the contents of the flat file
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
According to his methodology what all you need before you build a datawarehouse
What happens when a session fails and you click on recover?
Which are the different editions of informatica powercenter that are available?
Can u generate reports in Informatica?
Explain target update override in informatica
How to do unit testing in informatica? How to load data in informatica ?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Why filter transformation is an active one?
How we can create indexes after completing the loan process?
How to do the error handling of if ur source is flatfiles?
How to configure mapping in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.