Answer Posted / chinmay
Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
expain about the tune parameters?
What is domain in terms of informatica?
What is flashback table ? Advance thanks
Quickly characterize reusable change?
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 is rank index in rank transformation?
How big was your fact table
How to go to the older version for a mapping?
What is an aggregator transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is informatica etl tool?
What does update strategy mean, and what are the different option of it?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can you define user defied event?