Answer Posted / rajesh

select ‘(‘||substr(TNO,1,4)’)’||'_'||substr(TNO,5,3)||'_'||substr(TNO,8,3)) from TABLE_NAME

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

2087

---

Explain in detail about scd type 1 through mapping.

1628

---

What is aggregator transformation in informatica?

1004

---

How can we update a record in the target table without using update strategy?

1201

---

What is a snowflake schema?

1047

---

Explain joiner transformation in informatica

1171

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2353

---

What is domain in terms of informatica?

1056

---

On which transformations you created partitions in your project?

1433

---

Explian the Process of deployment groups in informatica

1102

---

Reusable transformation and shortcut differences

1880

---

Partition, what happens if the specified key range is shorter and longer

2552

---

Can we create two repositories on same database instance in oracle?

1142

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2254

---

how to load rows into fact table in data warehouse

1229

---