Answer / Amit Trivedi

A Session in Informatica is a container for one or more transformations, target mappings, or workflows. It defines the flow of data through the system. A Batch in Informatica refers to a single execution of a session. A batch processes a set of records according to the specified parameters and generates a result.

what is metadata?

6 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

How do you load only null records into target? Explain through mapping flow.

1 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1 Answers  

---

Have you worked with/created Parameter file

1 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

What is galaxy shema

2 Answers   CGI,

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1 Answers  

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

1 Answers  

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---