My source is delimited flat file Flat file data is H|Date
D1|ravi|bangalore D2|raju|pune T|4 The data will be send to
target if the fallowing two conditions satisfied 1.The first
row Date column is equal to SYSDATE 2.Last record second
port equal to number of records. How to achieve?
Answer Posted / shri
The data flow will be
SQ -> aggr T/R -> filter ->target
In aggr T/R define a new port(let X) and find the count of the total records using count(column Name)
In filter write the condition like
IIF((date=sysdate) and (x=y),1,0)
where y=last record port name
If im wrong,let me know the right answer els give a reason lik y its wrong. hope some one replies
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain sql transformation in script mode examples in informatica
How to Create a folder using pmrep command?
How we can create indexes after completing the load process?
Explain load alternative records / rows into multiple targets - informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the types of lookup transformation?
What is a node in Informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
In warehouses how many schemas are there?
Describe the impact of several join conditions and join order in a joiner transformation?
How to generate sequence numbers using expression transformation?
difference between informatica 8.1.1 and 8.6
Differentiate between Load Manager and DTM?
While importing the relational source definition from the database, what are the metadata of source that will be imported?