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
- 6493 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
What is sorter transformation?
Explain why we use partitioning the session in informatica?
How can repository reports be accessed without sql or other transformations?
Why filter transformation is an active one?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to load last n records of file into target table - informatica
What is the use of code page?
What is Cognos script editor?
What are the different transaction levels available in transaction control transformation?
Mention some types of transformation?
Explain what is informatica metadata and where is it stored?
Performance tuning( what you did in performance tuning)
How to load the data from a flat file into the target where the source flat file name changes daily?
Describe expression transformation?
