Interested to Buy Any Domain ? << Click Here >> for more details...
Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 11328 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer Posted / joe
1. Use a sequence generator to associate a NEXTVAL to the
row.
2. Filter condition : NextVal <=20
For source- dbase: Do a filter at SQ by including the
following condition . WHERE Rownum <=20
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
What are the restrictions of union transformation?
What is rank transformation in informatica
What is a stored procedure transformation?
What is the meaning of up gradation of repository?
Can we override a native sql query within informatica?
What is a sequence generator transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
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 degenerated dimension?
What is an active transformation?
What is the status code in stored procedure transformation?
What is a sorter transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Which are the different editions of informatica powercenter that are available?
