Answer Posted / niranjana
Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to configure mapping in informatica?
Explain how many types of dimensions are available in informatica?
What are active and passive transformations?
Differentiate between Load Manager and DTM?
Is stop and abort are same in informatica?
how tokens will generate?
Explain what are the different versions of informatica?
What is meant by LDAP users?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What do you mean by channel change?
What is substr in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Why is sorter an active transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
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.