If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / rajesh
in rownum not support grater than so use in filter
transformation iif(rownum<50,false,true)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
Informatica Checkpoints
How to update a particular record in target with out running whole workflow?
what are the deliverables?in your project?
What are multi-group transformations?
What is Cognos script editor?
How do you migrate data from one environment to another?
Explain the informatica workflow?
What is the need for an etl tool?
How do you change a non-reusable transformation to reusable transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Do you find any difficulty while working with flat files as source and target?
How can one identify whether mapping is correct or not without connecting session?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is incremental aggregation?