Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 7091 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridhar
if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / seshagiri k
By using Target load order plan and based on primary foreign
keys to load the data into n no of dimensions
If it wrong pls send the correct answer to my mail
| Is This Answer Correct ? | 1 Yes | 4 No |
What are connected or unconnected transformations?
What is aggregate cache in aggregator transforamtion?
how the server recognises , if the session fails after loading the 100 records in to the target
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
if i have a delimited file as source so how can we seperate this file into three diff targets?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How to recover sessions in concurrent batches?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the different types of Type2 dimension maping?
what is system requirement(SR) & business requirement(BR)?
Teradata 
