Answer / mithilesh kumar rai

step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.

step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.

Answer / davankumar

1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...

Answer / vidyadhar tilve

use transaction control

Answer / ramakrishna

simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

in which situations do u go for scds ?

3 Answers   TCS,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

---

why we use materialized view over view?

1 Answers   Zensar,

---

What is degenerated dimention table?

7 Answers   Patni,

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  

---