what is difference between dimention table and fact table?
Answer / guest
dimensional table stores the textual description of data
whereas fact table stores numerical values.
| Is This Answer Correct ? | 12 Yes | 3 No |
what is informatica metadata?
Explain lookup transformation is active in informatica
what is constraint based load order
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
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.
During the running session, output files are created by informatica server. Enlist few of them.
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
what is parallel querying and what r hints.
How can you join two tables without any common column present in them?
What are some examples of informatica etl programs?
What are reusable transformations in how many ways we can create them?