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
- 7710 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
What are roles and groups and benefits of using them?
How many dimensions are there in informatica?
Name the different lookup cache(s)?
what is the difference between informatica6.1 and infomatica7.1
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Slowly changing dimensions, types and where will you use them
what is diff b/t sorter t/r and agg have the option sorter property...
what are the deliverables?in your project?
How do you load only null records into target?
lookup transformation with screenshots
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can we create a node as a gateway node and the same node can be assigned to a grid?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
