Answer Posted / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

explan ur project architecture?

1581

---

Explain how many types of dimensions are available in informatica?

577

---

Explain the pipeline partition with real time example?

637

---

How do you use reject loader.

2052

---

4 yrs etl devloper roles and responsibilities?any body give solutions

1560

---

---

Please let me know how to make encryption and decryption with example?

1447

---

What is a stored procedure transformation?

601

---

What is a predefined event?

648

---

What is sequence generator transformation in informatica?

604

---

What is domain and gateway node?

683

---

Which files are created during the session rums by informatics server?

695

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

617

---

What do you mean by enterprise data warehousing?

629

---

can anyone suggest best free Talend data integration training online

1245

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3429

---