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
- 6581 Views
- Sapient, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the types of error logs available in Informatica?
How to load last n records of file into target table - informatica
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What is data merging, data cleansing and sampling?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
What is the use of source qualifier?
one source to target loading insert new rows and update existing rows?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
design of staging area?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
Teradata 
