i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 8431 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
we can also do it like this
FIRST PIPELINE
From sq connect all the ports to expression t/r and by using sequence generator t/r generate sequence number.
From expression t/r connect the all the ports to the filter t/r write a condition sno=1.
from filter t/r connect all the ports to the target
SECOND PIPELINE
From sq connect all the ports to Aggrigator t/r and dont group by any port,connect the ports to the target
THE DATA FLOW DIAGRAM WILL BE LIKE THIS
sequencegenerator
|
\|/
src--->sq--->expression--->filter--->trg
|
|-->aggrigator--->tgr
I think this will work
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is a surrogate key?
What are the types of caches in lookup?
what is mean by complex business rule ?
What is the procedure for creating independent data marts from informatica 7.1?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
wf dont have integration severances how you can run?
How many dimensions are there in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Is it possible to use a client with different version than that of its Informatica server?
Can we create a Integration service without a Repository service and vice versa?
What do mean by local and global repository?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is enterprise data warehousing?
What is informatica powercenter repository?
