Interested to Buy Any Domain ? << Click Here >> for more details...
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
- 6 Answers
- 15311 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh rathore
Src->sq->seq_gen->exp\_joiner->flt->tgt
---------->agg/
create a new port for count in agg and one dual port we assign 1 in that
and in exp also we add a port dual =1
we give condition in joiner on dual port
Write a logic in FLTR as "SEQ_PORT!=1 AND (count-SEQ_PORT)!=0"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which is the t/r that builts only single cache memory?
What is an aggregator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to generate or load values in to the target table based on a column value using informatica etl tool.
server hot-ws270 is connect to Repository B. What does it mean?
what is the -ve test case in your project.
What is domain and gateway node?
What are Dimensional table?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How can we use mapping variables in informatica? Where do we use them?
How to create the source and target database connections in server manager?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What do you understand by SOA of Informatica?
What are the components of Informatica? And what is the purpose of each?
What do you mean by enterprise data warehousing?
