can any one explain me about junk dimension
Answers were Sorted based on User's Feedback
Answer / mike
the dimension which contains the qttribute that changes
very rarely is known as junk dimension.
correct me if i was wrong
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ravi
A junk dimension is one which is combination of different
small dimensions
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / usha
It’s a dimension table which is used to keep junk attributes
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / akash
A junk dimension is a combination of attributes which are
rarely used.
Is This Answer Correct ? | 0 Yes | 2 No |
What could be the possible resons of locks by user?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is the difference between a repository server and a powerhouse?
How many number of sessions can one group in batches?
How many transformations can be used in mapplets.
Explain the use of aggregator cache file?
What is limitations of truncate and load option
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Under which circumstances, informatica server creates reject files?