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
- 6582 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
How to do the error handling of if ur source is flatfiles?
Write the program through which the records can be updated?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are multi-group transformations?
What are the main issues while working with flat files as source and as targets ?
Why is sorter an active transformation?
Explain the different kinds of facts.
Informatica Checkpoints
What is data caches/ index caches?
How to elaborate tracing level?
Explain the types of lookup transformation?
How would you copy the content of one repository to another repository?
What is workflow? What are the components of the workflow manager?
How to join three sources using joiner? Explain though mapping flow.
As union transformation gives UNION ALL output, how you will get the UNION output?
