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
- 6444 Views
- Sapient, I also Faced
- E-Mail Answers
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 condition selecting sorted input in aggregator may fail the session?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain your project of banking domian.
How to update or delete the rows in a target, which do not have key fields?
What is the difference between informatics 7x and 8x and what is latest version?
What are the tuning techniques you applied during your last project
What are the various types of transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to use procedural logic inside infromatica?
What is the surrogate key?
How many transformations can be used in mapplets.
What's the layout of parameter file (what does a parameter file contain?)?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to generate sequence numbers using expression transformation?
