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
How can we improve session performance in aggregator transformation?
What is the command used to run a batch?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is session task and command task?
Explain load alternative records / rows into multiple targets - informatica
What is dynamic cache?
What is meant by incremental aggregation?
What is joiner change?
Target increases every day even though no new record was inserted
Write the different tools in the workflow manager?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the use of transformation?
What are different types of transformations available in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How many number of sessions can one group in batches?