in which situations do u go for snowflake schema ?
Answer Posted / giri
it will used at time u will maitain normalised data u r
data having more cordinality dat tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
During the running session, output files are created by informatica server. Enlist few of them.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Did u used latest transformations of 8.6.0? for what?
What is the difference between Active and Passive transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Does an informatica transformation support only aggregate expressions?
Is it possible to create multiple domains on a single Informatica server?
what are the Methods For Creating Reusable Transformations?
In how many ways we can create ports?
Can we get 1st record through Informatica(without sequence number).
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?
Enlist some properties of sessions.
how many types of dimensions are available in informatica?
what are 3 tech challenges/ common issues you face?