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
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
What differs when we choose the sorted input for aggregator transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is informatica powercenter repository?
Explain what are the different types of transformation available in informatica.
permutations of mapplet
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Make a note of the quantity vaults made in informatica?
Please let me know how to make Data masking in informatica..
What happens when a session fails and you click on recover?
Informatica settings are available in which file?
How to Create a folder using pmrep command?
Differentiate between a repository server and a powerhouse?
Can we create two repositories on same database instance in oracle?
Define Pmrep command?
Enterprise data warehouse your projects phase by phase explain?