Interested to Buy Any Domain ? << Click Here >> for more details...
What are two types of processes that informatica runs the
session?
- 2 Answers
- 19289 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
Load manager Process: Starts the session, creates the DTM
process, and sends post-session email when the session
completes.
The DTM process. Creates threads to initialize the session,
read, write, and transform data, and handle pre- and
post-session operations.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is dimensional table?
Explain lookup transformation source types in informatica
What is the difference between stop and abort in informatica
Explain the different dimensions.
What is workflow? What are the components of workflow manager?
EXL informatica Questions
What does reusable transformation mean?
Explain the shared cache and re-cache?
What differs when we choose the sorted input for aggregator transformation?
Explain Dataware house architecture .how data flow from intial to end?
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.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a shortcut and copy in Informatica and how two are different with each other?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
As union transformation gives UNION ALL output, how you will get the UNION output?
