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
- 34327 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / eswar
As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")
Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).
note: use two target table in which u want to load that two
records
====
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How you can differentiate between connected lookup and unconnected lookup?
Explain the features of connected and unconnected lookup.
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 will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is data movement mode in Informatica and difference between them?
What is the use of code page?
What is union transformation in informatica?
Differentiate between sessions and batches?
What is a code page?
Explain the scenario which compels informatica server to reject files?
What is the commit type if you have a transaction control transformation in the mapping?
What is a mapplet/worklet in informatica?
What is enterprise data warehousing?
What is meant by query override?
