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
- 4478 Views
- I also Faced
- E-Mail Answers
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 |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is rank transformation?
How can i send first half of the records to one target and Remaining to other target?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
whatis the default data driven operation in informatica
What is the meaning of decode in informatica?
what is the mechanism of the Master-Detail joining condition?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is the sequence generator transformation in informatica?
Teradata 
