Answer Posted / sambasivarao.m
First understand the requirements,if any thing not
understandable then sent a mail to client, request for make
sheduled call and as well as in that mail mention what
would be discuss on call.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Differentiate between joiner and lookup transformation?
How to generate sequence numbers using expression transformation?
What the difference is between a database, a data warehouse and a data mart?
Explain direct and indirect flat file loading (source file type) - informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the Process to creating lookup transformation in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
whats the logic to load the lower level of granularity of data to fact table.
what is the hint? how to use it to reduce the query processing in program?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the function of union transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain what are the different types of transformation available in informatica.
