Answer Posted / kiran

source-sq-exp-tgt
in exp take two new ports
o1- substr(string,2,1)
o2-concat('20',(substr(string,3)))

let me know if i m wrong

What are the data movement modes in informatica?

1211

---

Explain the difference between mapping parameter and mapping variable?

1083

---

how to load rows into fact table in data warehouse

1234

---

What are the main features of Oracle 8i with context to datawarehouse?

2164

---

How to handle decimal places while importing a flatfile into informatica?

1242

---

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 ?

7370

---

What is the status code in stored procedure transformation?

1236

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2436

---

Why do we need informatica?

1054

---

What is a stored procedure transformation?

1113

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2204

---

What are the uses of etl tools?

1179

---

What do you mean by enterprise data warehousing?

1109

---

explain abt ur project architecture?

2236

---