Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
- 8 Answers
- 9997 Views
- TCS, I also Faced
- E-Mail Answers
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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to do unit testing in informatica? How to load data in informatica ?
What is the difference between stop and abort in informatica
What are the tasks that can be performed using sq?
hi real timers . iam waiting for ur reply regarding ETL TESTING
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Define sessions in informatica etl?
What are the new features of informatica 9.x at the developer level?
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
differences between service based and product based?
According to his methodology what all you need before you build a datawarehouse
can u any challenge your project?
Write the unconnected lookup syntax?
How to join three sources using joiner?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
