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
- 10584 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi,
Check with Normaliser Transformation
it will help you.
Any queries !! let me know
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
Plz can any one say me how to get the informatica certification materials and dumps
How to do the error handling of if ur source is flatfiles?
what is song in infrmatica...?
where to store informatica rejected data? How to extract the informatica rejected data?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can we create a Integration service without a Repository service and vice versa?
Repository user profiles
Explain the informatica workflow?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the difference between informatica6.1 and infomatica7.1
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
