If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / nitin
Use a sequence generator Transformation to filter the
records from 50 to 100 and then load to Target.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
expain about the tune parameters?
How to generate sequence numbers using expression transformation?
Under what condition selecting sorted input in aggregator may fail the session?
How to do the error handling of if ur source is flatfiles?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is domain in terms of informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
wat are deployement groups in informatica, how it will be used for developers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is unit testing?tell me proceedure
How to differentiate between the active and passive transformations?
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