Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
Answer Posted / bsgsr
hi, raju patel.
ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
your answers.
i believe you have good experience with the industry. since
when have you been working with the industry. can i have
some of my queries cleared only if you dont
minddddddddddddddddd!!!!!!!!!!!!. revert back to me on my
id bsgsr12@gmail.com also provide me your number if you
dont mind. take care
Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is aggregate cache in aggregator transformation?
Under which circumstances, informatica server creates reject files?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Where do we use mapping variables in informatica?
What does command task mean?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
explain one complex mapping with logic? sales project?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the settings that you use to configure the joiner transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How can we store previous session logs?
How you know when to use a static cache and dynamic cache in lookup transformation?