Interested to Buy Any Domain ? << Click Here >> for more details...
As per Informatica PC help guide, while adding
transformations to a mapplet,we have to keep this in mind:
If you use a Sequence Generator transformation, you must
use a reusable Sequence Generator transformation.
May i know the reason behind this?
- 2 Answers
- 5849 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santsoh kumar sarangi
reusable sequence generator will give some range of value
for one instance like 0-1000 for one instance and 1001-2000.
so it will not allow ambiguity in the number.
If you not use reusable sequence generator then if mapplet
is used by two mapping then it may happen that number one
will come to first mapping and number two will go to the
second mapping which will create confusion.
For that reason mapplet ask for reusable sequence generator.
Let me know if i am wrong.
Santsoh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / hardeepsingh83
I am not able to identify the reason behind this point.
If I am using a mapplet in 2 diff mappings and using
reusable seq generator(as per infmt guide) then both
mappings will get seq values accoriding to same Seq gen
transformation, which may not be required always or create
data issues.
Any body knows the exact reason behind it?
| Is This Answer Correct ? | 1 Yes | 3 No |
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
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?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
in what type of scenario bulk loading and normal loading we use?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Normalizer transformation is not involved in Mapplet.. why???
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
Teradata 
