write a query row to column follwing source?
quarter sales
q1 5000
q1 9000
q1 7000
q1 6000
q2 5000
q2 4000
q2 3000
q2 1000
q3 4000
q3 3000
q3 1000
q3 2000
q4 5000
q4 400
i want the output?
q1 q2 q3 q4
sales
- 3 Answers
- 6711 Views
- Cognizant, Flextronics, I also Faced
- E-Mail Answers
Answer Posted / senthil kumar s
It wouldn't work many to one concept for Normalizer.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Different circumstance which drives informatica server to expel records?
Explain direct and indirect flat file loading (source file type) - informatica
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.
How to update a particular record in target with out running whole workflow?
What is the way to execute pl/sql script using informatica mapping?
What is a repository manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can informatica be used for an organization?
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.
What are the issues you have faced in your project? How did you overcome those issues?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
