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
- 9849 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 we load 365 flat file to a single fact table (target) as a history load in single mapping?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to delete duplicate row using informatica?
During the running session, output files are created by informatica server. Enlist few of them.
what is datamart
what is semi-additive fact?where did u used?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
What is resilience time?
when will we go for unconnected lookup transformation in Informatica?
Teradata 
