Interested to Buy Any Domain ? << Click Here >> for more details...
HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....
- 3 Answers
- 10402 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harish kakarlapudi
Hi Srinivas,
It is opp. to Normalisation process, so, i think that it
cannot be done using Normaliser transformation. Can you
give me any idea , pls...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do mean by local and global repository?
Explain the use of aggregator cache file?
How to do the error handling of if ur source is flatfiles?
What are the different clients of powercenter?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Is it possible to define a single node as a Gateway node as well as worker node?
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
Did u used latest transformations of 8.6.0? for what?
Describe data concatenation?
How can you increase the performance in joiner transformation?
What all are steps in up gradation of Informatica server?
What are the tasks that can be performed using sq?
What is a filter transformation?
