What are the challenges of Dataware housing in the future?
Answers were Sorted based on User's Feedback
I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.
| Is This Answer Correct ? | 2 Yes | 0 No |
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
how to sort date field in infomatica?
What is Collect performance data in informatica and what is the use of it.
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
What is the different lookup cache(s)?
From where we can start or use pmcmd?
what we require for D.modelling?
What is a shortcut and copy in Informatica and how two are different with each other?
What is the difference between OLTP and ODS?
What do you understand by a term domain?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.