Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 15605 Views
- I also Faced
- E-Mail Answers
Answer Posted / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are multi-group transformations?
Implementation methodology
Can we create a node as a gateway node and the same node can be assigned to a grid?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Where is metadata stored?
How big was your fact table
What is an unconnected transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain lookup transformation is active in informatica
What is a repository? And how to add it in an informatica client?
How can you define user defied event?
Differentiate between Load Manager and DTM?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
