How can we use external procedural logic in informatica?
What is fact? What are the types of facts?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what do u do when DB time takes more?in sap bi
Which transformation we use to convert 'NA' to 'Not Available'
what is the difference steps for data modeling?
Explain etl?
Explain different types of partitioning?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
what is session partitioning?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is tracing level and what are the types?
Can there be sub steps of etl steps?
Explain etl mapping sheets?
Difference between flat files and relational sources?