What are the new features of informatica 9.x at the developer level?

990

Define joiner transformation?

992

Explain sql transformation in script mode examples in informatica

1053

What is the session task and command task?

997

Tell me about Propagate functions in informatica

880

How to go to the older version for a mapping?

1032

In which transformation you cannot drag ports into it?

1255

Can we create multiple integration service on single repository?

1135

What do think which one is the better joiner or look up?

1151

What is a transaction control transformation?

1148

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2214

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1041

Enlist few areas or real-time situations where informatica is required.

1029

What is the Process to creating lookup transformation in informatica

987

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

4074