Interested to Buy Any Domain ? << Click Here >> for more details...
in my source i have 100 records, and 3 targets, i want to
load
1st record into 1st target,2nd record into 2nd target,3rd
record into 3rd target again 4th target into 1st target and
vice versa,how to achieve this?
- 3 Answers
- 13514 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / chandra
this can be done in two ways.....
1st one
after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3
the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3
or
we can use MOD function in EXP Tr we can done this
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
How to create the source and target database connections in server manager?
How we can create indexes after completing the loan process?
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?
What are the new features of Power Center 5.0?
What is fact table? Explain the different kinds of facts.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How many numbers of sessions can one group in batches?
Differentiate between a database and data warehouse?
What is a joiner transformation and why it is an active one?
where to store informatica rejected data?
What is expression transformation?
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?
In informatics server which files are created during the session rums?
How can we store previous session logs?
