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 / 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 |
Post New Answer View All Answers
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain the types of transformations?
What are the advantages of using informatica as an etl tool over teradata?
Where can we find the throughput option in informatica?
Explain the informatica workflow?
scenario where i can use only concurrent execution of workflow.
What do you mean incremental aggregation?
what is the difference between informatica6.1 and infomatica7.1
What is the use of an aggregator cache file?
Describe data concatenation?
Can we create a Integration service without a Repository service and vice versa?
How would you join a node to the already existing domain?
Write the program through which the records can be updated?
What are multi-group transformations?
How to extract sap data using informatica? What is abap? What are idocs?