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
- 6993 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
how many types of dimensions are available in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the types of schemas we have in data warehouse.
What is a code page?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the reusable transformation?
How do you handle two sessions in Informatica
Mention a few design and development best practices for informatica?
What are roles and groups and benefits of using them?
What are the different types of transformation available in informatica.
What are the guidelines to be followed while using union transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is target designer and target load order?
