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
- 6393 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
Differentiate between reusable transformation and mapplet.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the shared cache and re-cache?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the restrictions of union transformation?
What is the use of source qualifier?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you update the records with or without using update strategy?
update strategy transformation in informatica
What is a filter transformation and why it is an active one?
What are the main features of Oracle 8i with context to datawarehouse?
What is the need of etl tools?
What is the advantage of informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
