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?
Answers were Sorted based on User's Feedback
Answer / krish
first flow sq to agg (in agg do count(d1))name it as Y
take a another flow send that to aggg u will get the last
record of the second column name it as some X
send the two flows to router give the condition as that
date column as sysdate and X=Y
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How many repositories can we create in Informatica??
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
What are pre and post-session shell commands?
What are the different versions of informatica?
Explain what are the different versions of informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the different clients of powercenter?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
how many types of dimensions are available in informatica?
Difference Between ETL & ELT?
How do you take back up of repository?
Describe data concatenation?