Answer Posted / gopal
Collection of multiple fact tables surrounded by dimension is called galaxy or multistar or fact consultaion Schema.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
Clarify the aggregator change?
What is the difference between Active and Passive transformation?
whats the logic to load the lower level of granularity of data to fact table.
How to call shell scripts from informatica?
Explain your project of banking domian.
What are the differences between oltp and olap?
How can repository reports be accessed without sql or other transformations?
Write the unconnected lookup syntax?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How we can create indexes after completing the load process?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do you update the records with or without using update strategy?