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
- 4460 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
How might one distinguish in the case of mapping is right or not without associating session?
How you know when to use a static cache and dynamic cache in lookup transformation?
In which transformation you cannot drag ports into it?
wat are deployement groups in informatica, how it will be used for developers
How to differentiate between the active and passive transformations?
Explain lookup transformation in informatica
Sequence generator, when you move from develoment to production how will you reset
How do you load unique records into one target table and duplicate records into a different target table?
How to extract sap data using informatica? What is abap? What are idocs?
What are the databases that informatica can connect to windows?
Explain the different lookup methods used in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can u generate reports in Informatica?
What are the different options available for update strategy?
What are active transformations.
