Answer Posted / deepak aggarwal

No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.

What is status code in informatica?

1063

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1673

---

What is Session and Batches?

1147

---

What is a stored procedure transformation?

1108

---

What is meant by active and passive transformation?

1189

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5871

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1955

---

Why update strategy and union transformations are active?

1088

---

Parameter and variable differences

2104

---

What are junk dimensions?

1111

---

explain abt ur project architecture?

2230

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1110

---

Is there any way to read the ms excel datas directly into informatica?

1065

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7363

---

What is target load order?

1297

---