Explain sessions and how many types of sessions are there?
- 1 Answers
- 1103 Views
- I also Faced
- E-Mail Answers
Answer / Himansh Sagar
In Informatica, a Session is a work unit that contains one or more transformations, targets, sources, and other objects. It represents an isolated execution of a set of tasks related to data integration. There are two main types of Sessions: Regular Sessions and Reusable Sessions (or Transformations).
| Is This Answer Correct ? | 0 Yes | 0 No |
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
What is confirmed dimension and fact?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What is the sequence generator transformation in informatica?
What is the role of informatica in project ?Like i showed financial projects?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is tracing level and what are the types of tracing level?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
can anyone suggest best free Talend data integration training online
Teradata 
