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
- 9651 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
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Which transformation should we use to normalise the COBOL and relational sources?
Different sorts of metadata that stores in the storage facility?
design of staging area?
What is the use of an aggregator cache file?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the difference between STOP and ABORT options in Workflow Monitor?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is dynamic cache?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What does refresh system mean, and what are its distinctive choice?
How we can create indexes after completing the loan process?
