Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6388 Views
- Sapient, I also Faced
- E-Mail Answers
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
Did u used latest transformations of 8.6.0? for what?
How can we use mapping variables in informatica?
How to Create a folder using pmrep command?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
can we override a native sql query within informatica? Where do we do it?
complex mapping ur project u r invlve can u explain and give real time example give me ?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How we can use union transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How many ways a relational source definition can be updated and what are they?
what is song in infrmatica...?
What is target load order?
Can you use flat files in Mapplets.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
