Interested to Buy Any Domain ? << Click Here >> for more details...
What are Rapid changing dimensions?
- 1 Answers
- 5344 Views
- I also Faced
- E-Mail Answers
Answer / arun
A dimension which have frequent changes. These type of dimensions can be maintained by splitting up the frequently changing attributes in to sub dimensions (More like a Normalized structure), so history can be maintained with less storage. But retrieval may be time consuming.
| Is This Answer Correct ? | 2 Yes | 0 No |
How do you implement unconn. Stored proc. In a mapping?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Without using Lookup & Sequence Generator, How to generate Sequence?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
how we load the data from source to staging area
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Insert else update option in which situation we will use
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What is data movement mode in Informatica and difference between them?
Teradata 
