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
- 9764 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / saida
i think this data pivoting thats y v use normaliser T/R
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
What is workflow? What are the components of workflow manager?
Explain lookup transformation in informatica
Mention some types of transformation?
What are the new features of Power Center 5.0?
How to update a particular record in target with out running whole workflow?
How to Create a folder using pmrep command?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to do unit testing in informatica? How to load data in informatica ?
Explain constraint based loading in informatica
How can we use mapping variables in informatica? Where do we use them?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Enlist the advantages of informatica.
Explain informatica architecture - version 8 / 9
What is rank transformation?
