in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / chandrasekhar
You need to use MOD function based on you can filter it
out.. then you will get 1..10..20..30....like we will get it
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
What are mapplets? How is it different from a Reusable Transformation?
Explain how to import oracle sequence into informatica?
can anyone suggest best free Talend data integration training online
How we can use union transformation?
In informatica workflow manager, how many repositories can be created?
draw informatica architecture 8.6 ?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Why do we need informatica?
Briefly describe lookup transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain lookup transformation is active in informatica
Is it possible to revert a global repository to local one and why?