Answer Posted / naveen
POWERCENTER INFORMATICA
ABINITIO
DATASTAGE
HYPERION
OWB
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by LDAP users?
Explain how many types of dimensions are available in informatica?
Does an informatica transformation support only aggregate expressions?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the mapping variable usage example in informatica
can we override a native sql query within informatica? Where do we do it?
what is informatica metadata?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Have you worked with/created Parameter file
What are mapplets? How is it different from a Reusable Transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the format of informatica objects in a repository?
What is pmcmd command?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?