Can any one describe what is audit table briefly?how does it
look like
and what are the columns in it?
Answer Posted / rayudu
Audit Table is nothing but the table which contains abouut
your workflow names and session names .It contains
information abt workflow and session status and their details.
Regards,
rayudu
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What do you understand by a term domain?
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 ?
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
How many input parameters can exist in an unconnected lookup?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
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.
Is there any way to read the ms excel datas directly into informatica?
What do you mean by enterprise data warehousing?
COM components can be used in Informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How many types of sessions are there in informatica.please explain them?
What is native users?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
explain one complex mapping with logic? sales project?