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
- 6449 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
Difference between Target-based loading and constraint-based loading?
Mention a few design and development best practices for informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is fact table? Explain the different kinds of facts.
What is the commit type if you have a transaction control transformation in the mapping?
What is meant by active and passive transformation?
How do you use reject loader.
how to load dimension table and fact table. plz tell me the steps.
How you know when to use a static cache and dynamic cache in lookup transformation?
Which files are created during the session rums by informatics server?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can you generate sequence numbers without using the sequence generator transformation?
What is session task and command task?
What is main use of mapplet?
complex mapping ur project u r invlve can u explain and give real time example give me ?
