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?
- 3 Answers
- 6655 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 |
Answer / Jeetendra Srivastava
To achieve the conditions you described, you can use a combination of scripting and transformation functions within Informatica. Here's a simplified example using SQL expressions:
1. First row Date comparison can be achieved by adding a Transformation named 'IsFirstRow' with an expression like `IF_NULL(SYSDATE) = A[Date] THEN 'TRUE' ELSE 'FALSE'`.
2. Last record second port (number of records) comparison can be achieved by adding a Transformation named 'IsLastRecord' with an expression like `ROW_NUMBER() OVER (ORDER BY Date) = COUNT(*)`.
3. These transformations can then be used in a Workflow to filter or route the data based on the conditions.
| Is This Answer Correct ? | 0 Yes | 0 No |
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
4 yrs etl devloper roles and responsibilities?any body give solutions
how can one eliminate dupliacte data with out using distinct option?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What are the uses of a Parameter file?
How to extract sap data using informatica?
expain about the tune parameters?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are the types of data that passes between informatica server and stored procedure?
Teradata 
