If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 10216 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / rajesh
use condition rownum>=50 in filter transformation
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
how to create user defined function (udf) in informatica
How to update a particular record in target with out running whole workflow?
What is complex mapping?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is DR strategy for Informatica project?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the benefit of partitioning a session?
What is informatica etl tool?
What is the way to execute pl/sql script using informatica mapping?
Explain your project of banking domian.
What is a predefined event?
Mention some types of transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
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
