Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34332 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / prakash kumar kumhar
ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Enlist some properties of sessions.
Quickly characterize reusable change?
Target increases every day even though no new record was inserted
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
how many types of dimensions are available in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the types of caches in lookup?
Which version configuration tool used in ur project?
what is INFORMATICA TESTING process
Is it possible to define a single node as a Gateway node as well as worker node?
Does an informatica transformation support only aggregate expressions?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the types of data warehouses?
How can a transformation be made reusable?
