Answer Posted / koti

by using update overide option we can update the target
though we dont have any primary key in target.

target overload means some time in a single mapping no. of
targets can take place one source can be depend on other
target. then we have to decide which target has to execute
first....
ex: source1.... target1(date of birth is one column in
target 1)

source2(age is one column is source2).... target2

in the above example target1 should be execute first. then
only we can get age in source 2. because age is depends on
date of birth which is available is target1...
hope u understood. if any clarification mail to me:
manjulakoteswararao@gmail.com

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1842

---

What do you understand by term role-playing dimension?

1116

---

Explian the Process of deployment groups in informatica

1102

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

What is enterprise data warehousing?

1105

---

What is a node in Informatica?

1085

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7498

---

Can informatica load heterogeneous targets from heterogeneous sources?

1232

---

How can we store previous session logs?

1138

---

Do you find any difficulty while working with flat files as source and target?

1146

---

Differentiate between joiner and lookup transformation?

1159

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1907

---

What is xml source qualifier transformation in informatica?

1278

---

How to start a workflow using pmcmd command?

1306

---