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
- 4375 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
Is it possible to revert a global repository to local one and why?
explain one complex mapping with logic? sales project?
In development project what is the process to follow for an etl developer from day1
What is the use of code page?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain the pipeline partition with real time example?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What do you mean by blocking transformation?
Which development components of informatica have the highest usage?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
differences between service based and product based?
How to use pmcmd utility command?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
