Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
- 15 Answers
- 26578 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / praveen
You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are roles and groups and benefits of using them?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are active and passive transformations?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Why update strategy and union transformations are active?
What are multi-group transformations?
Have you worked with/created Parameter file
pmscmd startworkflow -sv
Explain pushdown optimization $pushdownconfig parameter - informatica
How many types of sessions are there in informatica.please explain them?
How do you convert single row from source into three rows into target?
EXL informatica Questions
