Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10009 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 |
Which will beter perform IIf or decode?
In informatica workflow manager, how many repositories can be created?
What are two types of processes that informatica runs the session?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
How can you join two tables without any common column present in them?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
What is IQD file?
Design a mapping to get year of join for each employee.
How to send duplicates to one target and unique rows to one target?target is empty
Teradata 
