If a table contains 100 records we have to fetch 50-100
records from source to target?how

Answer Posted / nitin

Use a sequence generator Transformation to filter the
records from 50 to 100 and then load to Target.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is persistent lookup cache?

598


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8534


complex mapping ur project u r invlve can u explain and give real time example give me ?

1836


What are connected or unconnected transformations?

626


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

611






How would you copy the content of one repository to another repository?

549


What is the Rank index port in Rank transformation?

666


How to load the data from people soft hrm to people soft erm using informatica?

558


Explain pmcmd command usage in informatica

699


Which version configuration tool used in ur project?

2762


Explain informatica architecture - version 8 / 9

665


What all join we can perform in LOOKUP transformation?

559


How to create or import flat file definition in to the warehouse designer?

609


In warehouses how many schemas are there?

581


In which transformation you cannot drag ports into it?

776