1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / anoymous

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can we find the throughput option in informatica?

598

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

629

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603

Which is the t/r that builts only single cache memory?

704

What are the new features of informatica 9.x at the developer level?

600




What is complex mapping?

631

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1446

Explain sessions. Explain how batches are used to combine executions?

585

Which files are created during the session rums by informatics server?

700

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1744

what is index?how it can work in informatica

1576

can you please explain me pre session and post session options?

6357

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1729

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1576

Different circumstance which drives informatica server to expel records?

549