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
- 34026 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
What is enterprise data warehousing?
What do you understand by SOA of Informatica?
Explain what is informatica metadata and where is it stored?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a node in Informatica?
What do you mean by channel change?
Clarify the aggregator change?
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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is decode in informatica?
how to create user defined function (udf) in informatica
What could be the possible resons of locks by user?
can you please explain me pre session and post session options?
What is decode in static cache?
What is union transformation?
