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
- 10816 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
What could be the possible resons of locks by user?
what is the size of your data warehousing?
what are cost based and rule based approaches and what is the difference?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
How to delete the data in the target table after loaded.
How do you manage the Parameter files while migrating your data from one environment to another environment?
explain different types of modeling.
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
what is degenerated dimension table with scenario
What does refresh system mean, and what are its distinctive choice?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
Teradata 
