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
- 6354 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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Is it possible to revert a global repository to local one and why?
what is size of u r database?
What is a repository manager?
What are the various types of transformation?
What if the source is a flat-file?
Which transformation is needed while using the Cobol sources as source definitions?
What are the different clients of powercenter?
Different qualification between a related rotate toward the sky and isolates look upward?
In which transformation you cannot drag ports into it?
What is a standalone command task?
How do you convert single row from source into three rows into target?
Explain the features of connected and unconnected lookup.
can we override a native sql query within informatica? Where do we do it?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
