i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
- 7 Answers
- 11721 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / vijay
Are you saying you want the first 7 records from the source
table?
If that is the case, write an override in source qualifier
and fetch by the row number. That would be the fastest
way.Load into target.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is session task and command task?
According to his methodology what all you need before you build a datawarehouse
What is the maplet?
If informatica has its scheduler why using third party scheduler?
How can repository reports be accessed without sql or other transformations?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain how to import oracle sequence into informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to generate sequence numbers using expression transformation?
What is a connected 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
What does role playing dimension mean?
How can one identify whether mapping is correct or not without connecting session?
What do you mean by filter transformation?
How to improve the performance of a session using sorter transformation?
