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
- 4436 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
What are ETL Tools?
What do mean by local and global repository?
What do you mean by enterprise data warehousing?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain the scenario which compels informatica server to reject files?
Define filter transformation?
How many ways are there to create ports?
How do you handle two sessions in Informatica
What are the measure objects?
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?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Write the unconnected lookup syntax and how to return more than one column.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many input parameters can exist in an unconnected lookup?
