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..?
Answer Posted / reena
use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
What are the tasks that can be performed using sq?
What are the different components of powercenter?
How can we store previous session logs?
What do you mean by enterprise data warehousing?
How many ways a relational source definition can be updated and what are they?
Sequence generator, when you move from develoment to production how will you reset
Explain in detail about scd type 1 through mapping.
What is the difference between STOP and ABORT options in Workflow Monitor?
What is confirmed fact in dataware housing?
What are the performance considerations when working with aggregator transformation?
What are mapplets? How is it different from a Reusable Transformation?
What are the guidelines to be followed while using union transformation?
What is informatica? Why do we need it?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?