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
- 4413 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 |
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
how to design mapping half of source table records into one target and remaining half into another target
checkout and checkin in informatica 8.6
What are the data movement modes in informatcia?
What is data movement mode in Informatica and difference between them?
What is the difference between OLTP and ODS?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
What are the data movement modes in informatcia?
How to delete duplicate records in a flat file source?
What is informatica powercenter repository?
Tell me about MD5 functions in informatica
Teradata 
