hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you
- 5 Answers
- 9119 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saida
i think this data pivoting thats y v use normaliser T/R
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sujana
use agg->grp by..
and then create 13o/p ports..and give condition for jan sal (iif month=jan,sal)..give appropriate conditions for remainng o/pports also...
crct me if m wrong
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anoymous
I think this reverse Data pivoting,
may be Normalizer T/r will use to achieve to target am not
sure..
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mukesh
make 13 columns and add expression transformation and as
out and put the conditions like MAX(if(month='jan',sal)),
same for other months. very simple...
| Is This Answer Correct ? | 0 Yes | 1 No |
How can you join two tables without any common column present in them?
What is source qualifier transformation in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the default source option for update stratgey transformation?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What is meant by a domain?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What is the difference b/w natural key and surrogate key
Design time, run time. If you don't create parameter what will happen
Can we use the mapping parameters or variables created in one mapping into another mapping?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Can u generate reports in Informatica?
Teradata 
