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
- 6355 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
Clarify the utilization of aggregator cache record?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is DR strategy for Informatica project?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the different types of olap? Give an example?
which one is better performance wise joiner or look up
What is the procedure for creating independent data marts from informatica 7.1?
What is dynamic cache?
What are the types of data warehouses?
tell me about your project functionality
How do you load only null records into target?
What are the restrictions of union transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How can repository reports be accessed without sql or other transformations?
