Answer Posted / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the need of etl tools?
What are the issues you have faced in your project? How did you overcome those issues?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is an aggregator transformation?
Sequence generator, when you move from develoment to production how will you reset
Under which circumstances, informatica server creates reject files?
How many dimensions are there in informatica?
what is the hint? how to use it to reduce the query processing in program?
r u done any partitions in ur project?
What are the performance considerations when working with aggregator transformation?
What does role playing dimension mean?
scenario where i can use only concurrent execution of workflow.
What are the components of workflow manager?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me