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
- 4565 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 |
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
when we use dynamic lookup,if condition matches what will be the o/p?
how to through logic of informatica using the push down optimization into oracle.
how to obtain performance data for individual transformations.
Define joiner transformation?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
Different qualification between a related rotate toward the sky and isolates look upward?
What is meant by incremental aggregation?
Teradata 
