Interested to Buy Any Domain ? << Click Here >> for more details...
What are Rapid changing dimensions?
- 1 Answers
- 5440 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 can you increase the performance in joiner transformation?
what is semi-additive fact?where did u used?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Can u generate reports in Informatica?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
How to load query faster,so that It will take less time to load?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Teradata 
