Interested to Buy Any Domain ? << Click Here >> for more details...
sir presently i am persuing my m.tech
recently i got job in tcs as fresher presently iam doing my
9 months project related to informatica can any one guide
me how to create fact tables what type of schemas must be
used and so on if so give ur mail ids so that i can contct
through it
- 1 Answers
- 4566 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
Fact tables will created by
(DBA people or senior architects) with PK-FK relation.
Mstly people will create PK-FK relation in facts After
loading the Data in Table).
Schemas : Mostly STAR Schema.
It will be useful for u ,,,,,,,,,,,
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
how we can load rejected record's at run time?(not through bad files)
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is the Default Source Option For Update Strategy Transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the function of union transformation?
Which version configuration tool used in ur project?
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?
scenario where i can use only concurrent execution of workflow.
Explian the Process of deployment groups in informatica
What is sequence generator transformation in informatica?
What are the various types of transformation?
Enlist the tasks for which source qualifier transformation is used.
How we can create indexes after completing the load process?
How can you generate reports in informatica?
