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
- 34484 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 are the types of schemas we have in data warehouse and what are the difference between them?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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
What is a difference between complete, stop and abort?
Have you worked with/created Parameter file
Explain what is informatica metadata and where is it stored?
How can you generate reports in informatica?
What is domain in terms of informatica?
What is a filter transformation?
What are the designer tools for creating transformations?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
how to load rows into fact table in data warehouse
What are mapplets? How is it different from a Reusable Transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
