for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
Answer Posted / pushpa
by default filter condition has the TRUE that means don't
worry whether the incoming data numeric or string.all incoming
data passed to the next transformation or target.
if we assign a condition manually sal=True.session is executed
successfully but even single record is not loaded into the
target.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
What is intricate mapping?
how to create user defined function (udf) in informatica
In development project what is the process to follow for an etl developer from day1
what is the hint? how to use it to reduce the query processing in program?
What is lookup transformation?
What is the sequence generator transformation in informatica?
How to extract sap data using informatica?
Write the prerequisite tasks to achieve the session partition?
what is degenerated dimension?
To import the flat file definition into the designer where should the flat file be placed?
Explain the different dimensions.
How we can create indexes after completing the load process?
What do you mean by blocking transformation?
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