Answer / ahalya inturi

target load plan defines order in which data extracted from
source qualifier transformation

Answer / srinivas

suppose i have 3 pipelines in a single mapping designer

emp source--->sq--->tar1
dept source--->sq--->tar2
bonus source--->sq--->tar3

my requirement is to load first in tar2 then tar1 and then finally tar3

for this type of loading to control the extraction of data from source by source qualifier we use target load plan

What is a transaction control transformation?

0 Answers   Informatica,

---

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

Reusable transformation and shortcut differences

0 Answers  

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

---

Differentiate between sessions and batches?

0 Answers  

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

What are the different types of transformation available in informatica.

0 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---