Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
- 3 Answers
- 9447 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prabhu
Junk dimension contains the data which are currently not
useful. we have to keep these data for feature analysis
purpose.
Whereas Confirm dimentions are common for multiple fact
table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sarvesh
merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / chaitanya
An interesting use for a junk dimension is to capture the context of a specific transaction. While our
common, conformed dimensions contain the key dimensional attributes of interest, there are likely
attributes about the transaction that are not known until the transaction is processed.
| Is This Answer Correct ? | 0 Yes | 0 No |
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What is sorter transformation?
How to fix the etl bugs..Tell me the process?
What is an active transformation?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
HOW TO YOU LOAD TIME DIMENSION
How to use procedural logic inside infromatica?
can we use self join in informaitca?
Teradata 
