What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
Answer Posted / 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 |
Post New Answer View All Answers
How can we create index after completion of load process?
What do you mean by worklet?
What is an expression transformation?
What is a filter transformation?
can u any challenge your project?
Enterprise data warehouse your projects phase by phase explain?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the types of caches in lookup?
Can we get 1st record through Informatica(without sequence number).
Which transformation should we use to normalise the COBOL and relational sources?
What is enterprise data warehousing?
How an expression transformation differs from aggregator transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is joiner change?
what is mean by complex business rule ?