Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load first and last record from a flat file
source to target?
- 7 Answers
- 29655 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / srinu
I have an IDEA,
After sql Trans,go with AGG,RANK transformation,
in RankTrans Properties set the rank 1 only---1 row returns,
In AggTrans Dont do any column for Group--Last row returns,
We need 2 Target tables. 1 for 1st record,2 for last record,
if u using the UNIONtrans one Target table is enough,,,
i think it wii help u,,,,,,srinu,,,,,,,,,
| Is This Answer Correct ? | 13 Yes | 4 No |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is index?how it can work in informatica
What is main use of mapplet?
What do you mean incremental aggregation?
What are ETL Tools?
What is a dimensional model?
Mention a few design and development best practices for informatica?
Explain the difference between mapping parameter and mapping variable?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are junk dimensions?
What are the features of complex mapping?
Explain pmcmd command usage in informatica
What are the types of data warehouses?
What are the informatica performance improvement tips
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
