i have thousand records in my source(flat file) i wanna load
990 records i don't want load first 5 records and last 5
records at informatica level?
- 3 Answers
- 7847 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sehaj
PASS RECORDS FROM SOURCE QUALIFIER TO EXPRESSION.
CREATE A VARIABLE WITHA GGREGATION AS COUNT N ASSIGN ITS VALUE AS 0.
CREATE TWO PARAMETRES N ASSIGN DEM VALUES.
FIRST ONE 5
SECOND ONE 995
.
IN EXPRESSION CREATE AN OUTPUT PORT AS NUMBER DATATYPE N IN THE EXPRESSION EDITOR WRITE....
SEQUENCE=SETCOUNTVARIABLE(VARIABLE NAME U CREATED).
NOW
ATTACH IT TO THE ROUTER
CREATE A GROUP AND ENTER CONDITION
SEQUENCE>5 AND SEQUENCE<995
CONNECT THIS PORT TO TARGET...
SEHAJ....
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
Explain Dataware house architecture .how data flow from intial to end?
Explian the Process of deployment groups in informatica
What are the different types of olap? Give an example?
How do you load unique records into one target table and duplicate records into a different target table?
How can we create index after completion of load process?
What are the various types of transformation?
what is the size of your data warehousing?
What is target load order?
What is union transformation?
Clarify the utilization of aggregator cache record?
4 yrs etl devloper roles and responsibilities?any body give solutions
Tell me about Propagate functions in informatica
Define update strategy?
What does command task mean?
