Answer Posted / koti
sq generator, filter transformations. write the condition
in filter transformation as select columns from table where
sno>21 and sno<30...
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is sequence generator transformation in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is the -ve test case in your project.
Enlist the differences between database and data warehouse.
What is rank transformation in informatica
what are the deliverables?in your project?
What is an expression transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
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
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How big was your fact table
explain abt ur project architecture?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.