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
- 6450 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 is mapping parameter?
scd methodology?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
What are the types of data that passes between informatica server and stored procedure?
What is the difference between unicode & ascii mode data movement in informatica?
How to load last 10 records of flat file in to the target?
what is constraint based load order
While migrating the data from one environment to another environment how would you manage the connections?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What is update strategy transform?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
in which situations do u go for snowflake schema ?
Teradata 
