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
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
Explain the informatica workflow?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is resilience time?
Different circumstance which drives informatica server to expel records?
What is a node in Informatica?
Write the unconnected lookup syntax and how to return more than one column.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
can you please explain me pre session and post session options?
What is the difference between informatics 7x and 8x and what is latest version?
What is Index Caches size?
What is the sql query overwrite in source qualifier in informatica
What are the new features of Power Center 5.0?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?