Answer Posted / bala ramesh

in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.

EXL informatica Questions

919

---

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

3435

---

What is blocking transformation?

704

---

What are the uses of etl tools?

633

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3492

---

---

What is the difference between router and filter?

636

---

What are the differences between a connected lookup and unconnected lookup?

638

---

What is repository manager?

526

---

Explain about cumulative Sum or moving sum?

612

---

What are the types of schemas we have in data warehouse and what are the difference between them?

512

---

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

710

---

How do you migrate data from one environment to another?

635

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

1792

---

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

696

---

whats the logic to load the lower level of granularity of data to fact table.

1786

---