Answer Posted / usha

constraint based loading:-we need to enable the option in
session properties....

the main use of this optione is used to load the data if
the tables have PK and Fk relationship (or)which is used to
load the data if the tables having parent and chaild
realation .....

if we diidnt enable this option session will fail

what is the hint? how to use it to reduce the query processing in program?

7622

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1984

---

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?

1439

---

Did u used latest transformations of 8.6.0? for what?

1821

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2348

---

Plz can any one say me how to get the informatica certification materials and dumps

1998

---

What is the use of target designer?

980

---

Scheduling properties,whats the default (sequential)

1887

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1048

---

Explain what are the different versions of informatica?

1030

---

What is rank transform?

940

---

can anyone suggest best free Talend data integration training online

1622

---

How do you update the records with or without using update strategy?

1050

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2060

---

What is meant by LDAP users?

1107

---