Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8026 Views
- Cognizant, Flextronics, I also Faced
- E-Mail Answers
Answer Posted / gm
SQL:
select quarter, sales from table_name
group by quarter, sales;
Informatica:
Source-SQ-Exp-Normalizer Trans.-Tgt
In Normalizer Transformation we can do row into column.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
Explain the etl program with few examples.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are multi-group transformations?
Define enterprise data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is informatica worklet?
What are the databases that informatica can connect to windows?
explan ur project architecture?
Where is metadata stored?
Does an informatica transformation support only aggregate expressions?
waht type of interface is used for testing the data in informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is enterprise data warehousing?
What are the different types of repositories created using informatica?
